F
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?
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?