Importing from Excel

C

Chris Gorham

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
 

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

Word macro that can call cells out of Excel for a find and replace 0
Integrating information from Word to Excel (not mail merge) 1
Formatting Text from Excel 1
Merging from an Excel file with graphics 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Importing From Excel... 5
Autonumber field in Excel that behaves the same as Access 0
Access 2003 versus Access 2007 Excel Import 0

Top