Trying to import Access Data into SQL Server

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135551 More actions · Answer 1

Is this a single shot migration ?

Did you have a look at the SSMA for access (freeware by MS )?

( SQLServer Migration assistant for access )

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Johan,

I was able to create a new Access Database, import the Access Table and append the Data into SQL Server.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Johan,

It appears that I have a lot of Access Databases to import into SQL Server, Years for it.:w00t:

I will probably need to automate a complicate process that occurs at Month & Year End.

The summary results will be in an Excel Workbook Format.

Thanks again.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/