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!

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]

???

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

All sorted!