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)
 BCP and Import/Export

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-04-09 : 07:40:46
CJ writes "I have a text file called le3.txt and I want to import it in a table on my SQL server. What is the proper syntax for this and conversely what is the syntax use for sending a table from SQL to Excel?

The file is a flat file and is comma delimited. I read the articles you have posted here but they failed to clear away the mud. Please advise

Thanks,
CJ"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-04-09 : 08:00:54
Read the chapter in Books Online titled "Importing and Exporting Data".

Jay White
{0}
Go to Top of Page
   

- Advertisement -