Import data with a macro?

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

Randy

I would like to create a macro that will "Get External Data", "Import" an
excel file from a floppy disk that was exported from a laptop into my
[Analysis Form] table. The excel files will have different names depending
on which laptop they came from. Is this possible? Thanks...Randy
 
Yes, depending upon how you need to "select" the file names (manually enter
the name; have ACCESS just go get all files on that disketter). You'll want
to use the TransferSpreadsheet action as the basis for the method.

Post back with more info about how you want to get the filenames.
 
Back
Top