User definined filename for DoCmd.TransferSpreadsheet?

[aranj]

User defined filename for DoCmd.TransferSpreadsheet?

My colleagues can't be trusted to import the data into a table using file->get external data -> import!

Everything works using:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tablename", "Excelfilename", True

But can I get a dialog box up for "Excelfilename" so that they can browse to a file? Or is there another way?

Many thanks.

 

[aranj]

Many thanks, as always.
The same old problem - if I knew what I was looking for (common dialog) I could've found it myself!
Thanks once again.

 

[niftysam]

Additional Question

Is there a way to create the table according to the Excel fields and then import the file from excel? My excel files will never have the same fields. Thanks

 

[niftysam]

yes, but I need it dynamically

 

[niftysam]

Thanks!!!!!!!!!!11

Pat, Thanks so much!!! I was thinking I needed to custom code adding a blank table with field definitions and then update this table.