It is confusing to create a link between Access and SQL Server.
I have an old application  created in Access 2010 .mdb format. 
I have an Windows 2010 computer with 64 bit...

Maybe a solution in two steps.The Excel files are placed in an inbox. A VBA macro will open each file and save the sheet as a TAB sep text file....

What experience do you have in this area?
Is the SQL server hosted on your computer or
on a separate server on your intranet?
If so you would probably logg...

I see it is some stuff I have written in VBA.
Have you changed the code to your local environment?
Data Source= yourSQLserver
Initial Catalog=yourdatabasename
With this code you...

James
This might be a solution:
If the users have a Access client with the front end, the database SQL server can the hosted in a server within your Intranet
(or...

I completely agree that you should not use spreadsheets to store data. As suggested you can use Access as a front end to SQL server
but you need to learn how...

"Even that has problems. First, a human has to press a button to do the export instead of being able to read the file at any time. Also,...

I agree with twin.devil

but I use vba in Excel. Search google like

"vba insert sql excel"

"This is perhaps not what you meant by 'Export' but it is another way to get data into a spreadsheet. It does not require SSMS or any add-in. It may...

"What I've been able to do (and I'm working on getting an article published on the subject) is I've been able to make all of that auto-magic. The import code...

Jeff

"Not that that's bad but it defines the very problem that I have with all such code. Quite literally, you have to at least look at the Excel spreadsheet, determine...

Jeff

I apologize for the too short and provocative statements.

As it was a while ago I used an ACE driver I did a test with a simple Excel file. On a...

Thank you all for this "debate"

I would nether recommend anybody to use SSIS or an ACE driver in order to import sheets in native Excel file format. This may...