|
Subject:
|
Link Tables thru VBA
|
|
Posted By:
|
Rchanga
|
Post Date:
|
11/19/2004 2:03:28 PM
|
How do I link AS/400 tables in to access database using VBA code.
Thanks
|
|
Reply By:
|
jemacc
|
Reply Date:
|
11/20/2004 10:06:23 AM
|
I believe you can use transferdatabase method to do that
DoCmd.TransferDatabase acLink, "Microsoft
Access", "DataImportedFrom.mdb",
acTable, "SourceTableName", "DestTableName"
Look up transfersdatabase method to get more details
Jaime E. Maccou
Applications Analyst
|
