importing records (tables or spreadsheets)

J

Jeremiah

i have used a macro to export tables as spreadsheets
allowing the user to specify the path for them to be saved
in.
I want to create a similar macro to import these tables or
spreadsheets back to access but also letting the user
browse for the files and choosing the place for the them
to be stored (or rather overwrite existing tables).

I have seen a How To (KB 279508) on using VBA to open the
Filedialog box to choose the files, but not the rest of
what i require. I want to tie the VBA to the onClick event
of a command button. Are there any other articles to help
with this?
many thanks
 

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

Import to many to many table 7
transfer spreadsheet/import command 1
Excel 2010 Table not showing in Access 2010 Import List 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Import spreadsheet and Trim initial space in Column A 4
Import Excel check field names Please Help 2
Import Excel ranges - clarify 20
Import Spreadsheet Problem 3

Top