upload data from ms access to sql server

Question

i have already created a schema in sql server. is there any quick way to upload the data from table to table from msaccess to sql server. what if the col names have changed slightly?

baldy · Accepted Answer · 2009-09-01 07:25:57Z

1

Just use the "Import Data" function, you can map source columns to destination columns

answered Sep 1, 2009 at 7:25

baldy

5,5514 gold badges24 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joe Caffeine · Accepted Answer · 2009-09-01 05:28:09Z

0

You can use DTS or SSIS depending on your version of sql server to load and transform data from any ODBC or OLEDB based data source.

answered Sep 1, 2009 at 5:28

Joe Caffeine

8785 silver badges10 bronze badges

Comments

shahkalpesh · Accepted Answer · 2009-09-01 05:44:28Z

0

Other than using DTS, you could create a Linked Table inside Access (which points to SQL Server table) and create INSERT queries to do that.

If the table structure is identical & if it is a one time job, you could do copy-paste from Access Table to SQL Server Table (when that is linked).

answered Sep 1, 2009 at 5:44

shahkalpesh

33.6k4 gold badges66 silver badges89 bronze badges

Collectives™ on Stack Overflow

upload data from ms access to sql server

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related