Export Data from Access 2003 Table to SQL Server 2012 Table.

[Robeen]

Hi,



I am looking for a really simple way to copy data [not the Table itself, necessarily] from a Table in Access 2003 to a matching Table in SQL Server 2012.

I would appreciate any help I can get!

Thanks!

[JoeM]

Try this:
Link your SQL table in to your Access database, then create and run an Append Query to write the data from your Access table to your SQL table.

[Robeen]

Thanks @JoeM!! I will certainly give that a try.

I was able to take an easier option to solve my immediate, one-time [hopefully] problem. I Ctrl-C'd the several hundred rows from Access - and then Ctrl-V'd them into the 'empty' last row of the SQL Server Table! Not 'elegant' but it works.
I am going to try it your way & I'll post back with how I fared. It seems a more useful way of doing it.

[JoeM]

You're welcome!

The key to using my suggestion is to set-up the data connection.
Here is an article that may help: https://support.office.com/en-us/art...7-f369b78d3db8