Import data with a macro?

[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

 

[Ken Snell [MVP]]

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.