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 2005 Forums
 Transact-SQL (2005)
 Basic BCP/Bulk Insert (Basic question)

Author  Topic 

Jim Beam
Posting Yak Master

137 Posts

Posted - 2010-09-30 : 10:37:51
Hi all,

I've got a 475Mb txt file I need to import into new (as yet non-existant) table, how would I use BCP/Bulk Insert to create the table on the fly (with the least amount of concern about how the new table columns map to those in the txt file)?

Thanks,

Jim
   

- Advertisement -