Need help with TransferDatabase comand, please.

[FatMan]

Hi all:
I am looking for help with the TransferDatabase command.

When the line of code below is executed I get an error message saying:

"The Microsoft Jet databse engine cannot find the input table or query
'tblGrowerProfile'. Make sure it exists and that its name is spelled
correctly."

Line of code:
DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\Program
Files\SprayRecGrower09V1a\SprayRecGrower09V1a.mdb", acTable, _
"tblGrowerProfile", "tblGrowerProfile"

Background:
- the table is from an Access table

- the full path to and name of the database that the table is bing import
from is C:\Program FIles\SprayRecGrower09V1a\SprayRecGrower09V1a.mdb

- the table name to be imported is tblGrowerProfile and I want it to be
called the same in the current database

Can anyone offer any help as to why this line of code will not work?

All help is greatly appreciated.

Thanks,
FatMan

 

[ryguy7272]

Here is a simple import macro:

Option Compare Database
Function Macro1()
DoCmd.TransferSpreadsheet acImport, 8, "Table1", "C:\Ryan\Ryan.xls",
False, "A1:Z1000"
End Function

Also, here is a link to some VERY useful code for all kinds of imports and
exports:
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm

HTH,
Ryan--