Simulate File->Get External Data->Import

[Guest]

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

--

 

[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.

 

[Dirk Goldgar]

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.

For picking the file, see

www.mvps.org/access/api/api0001.htm