Simulate File->Get External Data->Import

B

Ben

Hi all,

I need to simulate File->Get External Data->Import, to have user pick a file
for import. How can I accomplish this in code? I use Access 2002. Thanks
in advance.

Ben

--
 
F

fredg

Hi all,

I need to simulate File->Get External Data->Import, to have user pick a file
for import. How can I accomplish this in code? I use Access 2002. Thanks
in advance.

Ben

Look up the

TransferText (import or export text files)
TransferSpreadsheet (import or export spreadsheet files)
TransferDatabase (import or export database files)

methods in VBA help.
 
Top