Hi fellows!

I need to read from disk a TXT file, comma separated, then to populate to SQL table.
By default I was thinking into use streamreader.readline(), parsing every record in order to split each field, then execute INSERT command in order to write a new record into SQL table.
Because I can not forget my days of C (K&R code) I would like to ask if somebody can give some ideas, in order to use all features of C#.
Perhaps some functions, something at help, etc.

Regards



---
Ariel Folonier
San Nicolas
Argentina

__________________
---
Ariel Folonier
San Nicolas
Argentina

Hi,

your answer isn't in C#.
You have to use the "Bulk Insert" sql function.
If you use Sql Server, you'll find all details on the function in Transact-Sql Help

Hi there,
I have worked on "BULK INSERT" command but noticed that
to import a text file to sql by using "bulk insert" command
i do already have a table and import the text file into this table.
But there is a command called "openrowset" with this command
programmer does not have to have a table in database to import a text file by using "openrowset"
does anyone help me with this pls?
i need a command to import a text file into SQL Server 2000 automaticly
"openrowset" does not help me because it has no parameter that you can specify "rowdelimiter" or "fielddelimiter". "bulk insert" doenst help me because i must have a table in database.
as a result i need a command that should be able to do both of this command above. does anyone could help?
or may be there is another way to do it?