Parsing a text or excel file into a database

[Amy]

Does anyone know how to create an application that will automatically open
a file and parse it into a database? Trying to handle a file that has been
uploaded into a webserver and have the contents of the file parsed into a
database.

[michael]

If the file is already formatted correctly you can take a look at the bcp
command "bulk copy" in sql server. If the file is not formatted you can create
a work table and populate it via the bcp command then call a stored procedure
to massage the data and insert it into the proper tables with in the database.
The slowest alternative, if the above is not applicable, is to use the FileSystemObject.
Using the FileSystemObject, you will have to read through each line and
insert data one row at a time with insert statement.

Michael

"Amy" <gi_armybabe@hotmail.com> wrote:
>
>Does anyone know how to create an application that will automatically open
>a file and parse it into a database? Trying to handle a file that has been
>uploaded into a webserver and have the contents of the file parsed into
a
>database.