How can this be done?

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
 
S

Sonu Kapoor

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
VBA - retrieve data on last create named range from previous inserted named range 0
Can be done? 1
importing excel spreadsheets 2
Can this be done? 4
Can this be done in Access? 2
Can this be done? 1
Importing files 2

Top