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
 General SQL Server Forums
 New to SQL Server Programming
 move a tab file to SQL Express MDF file

Author  Topic 

russler01
Starting Member

5 Posts

Posted - 2006-10-12 : 21:03:32
How do I move a tab serperated file into a table in SQL express using sql express? I need simple fast way to to this.

I can export all my access file into tab or comma files and then build the new tables and import them. I tried upsizing the table in access but sql express will not accept them at all and I cant find a way around it.

Thakns

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-13 : 00:40:14
You can try to use SELECT * INTO MyNewTable FROM OPENROWSET(.....)


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -