import from mdb.

[Lasse T]

Hello

I have a module looking likt this:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\import.mdb", acTable, pricelist1, _
"import"

It is importing the table pricelist1 to the table import.

I would like to have more tables in the database where I import the data
from and let the user decide wich table to import. Is this possible? I also
would like to let the user select two ore more tables and have them all
imported to the table Import.

Next question.
If I change C:\import.mdb to http://servername/import.mdb or
ftp://servername/import.mdb Access tells me that there is an error with the
internet adress. How shall I write to make Access get the file from a web or
ftp server?

I hope anyone can help me with this.

Thanks in advance.

Lasse T
---------------

 

[Douglas J. Steele]

Access doesn't allow either http or ftp in this context.

You could try using FTP to transfer the database locally, and then use the
TransferDatabase method on that local copy. For information on how to use
FTP from within Access, you can check
http://www.mvps.org/access/modules/mdl0015.htm at "The Access Web" for a
simplistic approach, or http://www.mvps.org/access/modules/mdl0037.htm for a
more robust approach.