Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Moving Data from MDB to MS SQL Server

Author  Topic 

dudesnep
Starting Member

1 Post

Posted - 2007-03-15 : 03:26:17
Hi all,

I have an issue and I'm unable to arrive at a solution for the same.

I have some data existing on multiple tables in a .MDB. I wanted this data to be moved into a single table in MS SQL Server. Would be grateful if anyone could suggest a command/query to do the same.

Awaiting your replies.

Regards,
Sundeep

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-15 : 03:32:21
How could we suggest a query unless you specify the tables you have and their details?



Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-15 : 03:56:27
Have you tried the UPSIZE wizard?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-03-15 : 10:25:34
(Topic moved out of the Articles forum)

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -