Newby: import Access tables to MS SQL database

[danb]

Hi,

I'm currently migrating a website from using an Access database to an MS SQL database.

I'm quite new to MS SQL so this is probably easy - I just don't know how to do it: I'm trying to import my five Access tables to a new SQL Server database.

Do I have to set up the tables first before doing an import DTS, or can I get SQL Server to create the tables as it imports? If the latter, how do I do the import since it seems to only give me the import option when a table is selected. Even then, I can run a DTS package, it succeeds, but none of the data is transferred into my SQL Server tables?

Any help would be great, thanks!

 

[danb]

Okay, I think it is working actually, but it's creating all of the tables in:

[mydatabasename].[myusername].[tblMyTable]

I can't seem to get to this place!? Should it save them to:

[mydatabasename].[Tables].[tblMyTable]

???

 

[danb]

Okay, I've refreshed the table pane view and there they are! Oops, didn't realise it needed to be manually refreshed.

All sorted!

 

[wonn1377]

I think u should use a third party help to resolve this problem, i use dbload to solve it when i was migrated my data, it can migrate almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. i found it on google search dbload.
http://www.dbload.com

 

[exzant]

You can use Bullzip Access to MySQL converter

 

[Expert11]

Use convert db for such aim found on google search to convert databases.

Get Here :www(.)convert-db(.)com