Importing Excel data in a table

[Guillaume777]

Is it possible to import excel data in a table ?

 

[KeithG]

yes, just select File/Import and then choose .xls as the file type.

 

[Guillaume777]

yes, just select File/Import and then choose .xls as the file type.

Nice.

However I have some questions :

1. Is there a way to let the user import the excel document himself, with an interface that I will configure ?

2. While importing, is there a way to automatically skip lines that do not match some criterions ? ( like empty lines, lines with irrelevant data, etc.) I know I could do it with querry but I don't want the data base to be full of useless data...

3. Is there a way to add an extra field that corresponds to a specific cell in excel ? So if "Sales report #10" is in the B3 cell, all imported entries have "Sales report #10" in one of their field ?

 

[KeithG]

Yes, all that can be done with VBA, some tasks more difficult than others.

 

[Dwight]

Look at Ghudson's Browse code to allow the user to select an Excel file on the form you will create. This will tell the VBA code the file path.

http://www.access-programmers.co.uk/forums/showthread.php?t=97787

And take a look at the TransferSpreadsheet function in VBA to do the importing.

Dwight