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)
 Parsing Binary Data in SQL Server and Using DTS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-30 : 07:51:46
Jon writes "Can anyone tell me if there is method in SQL Server to parse data from a binary file into a table or multiple tables that have already been created? Can I do it in SQL Server or do I need to write some code in another language? The file is delimited by different code numbers followed by the real data...

Also, I have been trying to use the "Import Data Wizard" to import Excel and .txt files - Is there a way to specify different delimiters within a .txt file? Is there a way to tell the wizard to skip the first few rows in an Excel file?

I appreciate any help someone can provide..."
   

- Advertisement -