Inserting a Delimited Text File into SQL Server 
Author Message
 Inserting a Delimited Text File into SQL Server

Hi

Is there any way in VC++, using which i can read and insert a delimited
text file into a database assuming that the data in the demilited text
file maps to the columns in the database table. Your input will be
appreciated.

Thanks
Arun



Sun, 26 Dec 2004 04:04:21 GMT  
 Inserting a Delimited Text File into SQL Server
Yes, read the file, one line at a time, and parse the values.  Insert
the values parsed into the appropriate columns.


Sun, 26 Dec 2004 08:10:43 GMT  
 Inserting a Delimited Text File into SQL Server

Quote:
> Is there any way in VC++, using which i can read and insert a delimited
> text file into a database assuming that the data in the demilited text
> file maps to the columns in the database table. Your input will be
> appreciated.

see if 'BULK INSERT' helps u.

Nilesh Dhakras



Sun, 26 Dec 2004 14:08:37 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Inserting a Delimited Text File into SQL Server

2. Inserting a Delimited Text File into SQL Server

3. Trying to insert data into SQL Server

4. SQL Server: Slow INSERT performance??

5. Insert in SQL Server CTable<CDynamicAccessor>

6. OLEDB, Fail Insert, SQL Server 7

7. How to insert an image into SQL Server?

8. Inserting Muliple Records into SQL-SERVER Database

9. Inserting in to a SQL Server Database

10. connect to sql server and insert

11. How to insert image into SQL Server?

12. Inserting Binary data into SQL Server

 

 
Powered by phpBB® Forum Software