Automatically Import Data

[Bill M]

I am distributing an updated copy of an application and I want to
automatically import data from the existing version without user
intervention. I know about the DoCmd.RunCommand acCmdImport command, but
that requires user input.

Is there a way to automatically select the tables and data I want to import
without user intervention?

Thanks

 

[John Nurick]

Hi Bill,

One possibility might be not to import the data at all, but to use
linked tables in the updated application to access the data in the old
version. (Separating the application from its data store like this makes
distributing future updates vastly simpler.)

Otherwise, DoCmd.TransferDatabase lets you import data from another
database, specifying it all at programming time.

 

[Jeff C]

DoCmd.TransferText acImportDelim, "Your Import Spec", "Destination Table",
"Path to the file you are importing"