importing data to Access database

[farseer]

Hi,
i would like to write an app that will do the following:

1. download a csv file from an http url. fields are delimited by the
"|"
2. i would like to import this into an access database
2. i'd like the first row row to be disregarded, as it is the column
names
2. I need to also disregard the last row, but i still need to use it
else where, as it contains the time stamp indicating when the file was
last updated

What the best way to do this? Do i actually have to read line by line,
split the line to determine the fields, and then insert those using
some SQL statement in the database? or can i create some sort of
"spec" that will tell ado how to import this file?

Also, i noticed when i add an Access database to my C# project, it
generates some classes for me which seem to be data access wrapper. Is
that the preferred means of accessing the database?

[Cowboy (Gregory A. Beamer) - MVP]

Easy Options
---------------
1. StreamReader, Split, Insert.
2. DTS package
3. Access Import - not sure how to automate, however

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"farseer" wrote:

Hi,
i would like to write an app that will do the following:

1. download a csv file from an http url. fields are delimited by the
"|"
2. i would like to import this into an access database
2. i'd like the first row row to be disregarded, as it is the column
names
2. I need to also disregard the last row, but i still need to use it
else where, as it contains the time stamp indicating when the file was
last updated

What the best way to do this? Do i actually have to read line by line,
split the line to determine the fields, and then insert those using
some SQL statement in the database? or can i create some sort of
"spec" that will tell ado how to import this file?

Also, i noticed when i add an Access database to my C# project, it
generates some classes for me which seem to be data access wrapper. Is
that the preferred means of accessing the database?