Suggestions on reading in a database?

[cz007j]

hi everyone, I'm slightly baffled at this little problem. I want to know if anyone's got quick suggestions.

 

I am using ASP.net with vb.net in the backend. I have to make a page that takes an uploaded excel, or txt, or access file, and read the two columns. Anyone have any good ideas on how to do that? I looked into filestreams and all, but just not sure which format would be easier to read, quick converstion protocols or such.

 

Thx in advance

 

cz

[PlausiblyDamp]

For access you will want to use ADO.Net rather than parsing the file structure yourself. Excel could be done either through ADO.Net or via interop (requires Office installed on the server to work though)

For a text file then use the classes from System.IO (probably find StreamReader is a good starting point)

[cz007j]

For access you will want to use ADO.Net rather than parsing the file structure yourself. Excel could be done either through ADO.Net or via interop (requires Office installed on the server to work though)

For a text file then use the classes from System.IO (probably find StreamReader is a good starting point)

Hmm....do you have any instructional sites that I can look up on to do this? I've got a vb.net book, but that doesn't cover much.

 

thx