How can this be done?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need to create a small app which users will use to import data from excel
files to be sent to a database. How can I use VB to check the structure of
the files before importing. It will basically have 4 columns. I don't want
them to select any excel files. The program should make sure the columns are
present with the correct data.

Where can I find info on this?

Thanks
 
You should make sure that the user can submit only CSV files, then you can read the CSV files via simple File.IO or StreamReader line by line and add it to the dbase. Check MSDN for an example to read a file.

Sonu Kapoor [MVP]
 
Back
Top