more import defaults

  • Thread starter Thread starter R
  • Start date Start date
R

R

Again, importing data via a macro.

Is there a way to ALWAYS use the saved import specs rather than make the
user select them?

Is there a way to specify the name of the file that will ALWAYS be used to
save the new table?

Seems I'd done this a long time ago via macros - but the macro options
seemed to have changed since then.

Thanks for the help...

-R
 
in Access 97 and 2000, those arguments can be set in the
macro design view window, in the Action Arguments section
in the bottom half of the window.
 
Thanks Tina.

It's odd, because I recall that being how it worked. I don't see that,
though, in my version - and I'm using 2000!

Are you using RunCommand/Import as the macro function? Or some other
method?

Thanks again...

-Renee
 
Renee,

The TransferText macro action is likely more applicable.

- Steve Schapel, Microsoft Access MVP
 

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

Macro Conditions 1
Importing Text Files Into Access 1
Access Saved Import details 5
Import Spreadsheet Problem 3
Office 2007 TransferSpreadsheet Import 5
Transfer text 1
Bulk Import DBF files to access 2003 1
Export table to txt file with a variable filename 0

Back
Top