Replace Access with Excel?

[Dr. Logic]

I have an SQL database and to do little editing things and stuff I use linked tables in Access.

I already know how to import external data queries from SQL to Excel, but in Excel it's always been a one way thing.

But in Access, I can actually CHANGE the data in the SQL database because the Access table is LINKED.

Can Excel do that? (I'm using Excel 2010)

Thanks!

 

[Dr. Logic]

bump

 

[SydneyGeek]

Please don't bump posts within 2 minutes of the original post.
You could do yourself a disservice because the post has then been officially answered, and users who go looking for unanswered posts will miss yours. Give it several hours before bumping.

Back to the question...

You can, by using ADO code to link to the SQL backend.

You need to pull in the ID from the table, so that you can identify the record uniquely.
Take a look at this tutorial which shows how to do it with Access (7 parts -- work your way through, one of them shows how to edit records). For SQL Server you need a different connection string and will need to include the user name and password. Go to connectionstrings.com for the connection string.

Denis

 

[Dr. Logic]

Thanks Sydney,

But I was trying to edit SQL with Excel, not Access.

Is that possible without going through all the usual import export tasks?

I can do it with Access, (query SQL and make little changes) but with Excel I can only query SQL, I can't seem to make direct changes.

 

[SydneyGeek]

That tutorial is based around using Excel as the front end. I wrote it with Access as the back end but you should be able to do the same with SQL Server as the back end.
The SQL all originates from Excel.

Denis