Importing from Excel

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

Guest

Hi,

firstly, thanks to Nikos Yannacopou for solving my exporting to Excel issue...

I'm currently importing data into Access 2000 from Excel 2000 using
DoCmd.Transfer Spreadsheet.

This works fine but requires the path of the Excel file as one of its
parameters. I currently use an InputBox to request this from the user and
store the result in the registry for subsequent imports.

This all works fine but its a bit "clunky". I would like to bring up the
standard file selection menu and allow the user to navigate towards the
target Excel file.

I also want to avoid the standard Access wizard for importing spreadsheets
appearing - I test for field headings, number of fields and data formats so
I don't require it.

Thanks...Chris
 
Back
Top