Import Excel Using TransferSpreadsheet

[Karie M. via AccessMonster.com]

I'm using the Macro TransferSpreadsheet to transfer excel file to Access.
But, it keeps giving me an error that Microsoft jet engine cannot find the
object "c:\fixup.xls" The pathand name is correct.

I don't understand why it cannot find my file. Does anyone know why or what
I'm doing wrong??

Thanks,
Karie

 

[Klatuu]

You are probably putting it in the wrong place.
Table Name is where you put the name of the table you are going to put the
data into.
File Name is where you put the path and name of the spreadsheet you want to
import.
I tried putting the excel path and file in the Table Name box and got the
error you described.

 

[Karie M. via AccessMonster.com]

Under table: i have the table name
File name: i have the file name.

But keep getting the error. I've placed the file everywhere.... c:\ And c:\
docs etc. and point to in under file name, but I still receive the error.

Could there be something else wrong??
Thanks,

You are probably putting it in the wrong place.
Table Name is where you put the name of the table you are going to put the
data into.
File Name is where you put the path and name of the spreadsheet you want to
import.
I tried putting the excel path and file in the Table Name box and got the
error you described.

I'm using the Macro TransferSpreadsheet to transfer excel file to Access.
But, it keeps giving me an error that Microsoft jet engine cannot find the

[quoted text clipped - 5 lines]

Thanks,
Karie

 

[Karie M. via AccessMonster.com]

I discovered something else. When I change the path to c:\docs, it gives me
the error that it can't find c:\documents and setting\my documents . It as
though it defaulting to something else.

Thanks,

You are probably putting it in the wrong place.
Table Name is where you put the name of the table you are going to put the
data into.
File Name is where you put the path and name of the spreadsheet you want to
import.
I tried putting the excel path and file in the Table Name box and got the
error you described.

I'm using the Macro TransferSpreadsheet to transfer excel file to Access.
But, it keeps giving me an error that Microsoft jet engine cannot find the

[quoted text clipped - 5 lines]

Thanks,
Karie

 

[Klatuu]

If it is trying to chnage c:\docs to c:\documents and setting\my documents,
that sounds like it it trying to translate from short file names to long.
What version of Access and what version of Windows are you on?

I discovered something else. When I change the path to c:\docs, it gives me
the error that it can't find c:\documents and setting\my documents . It as
though it defaulting to something else.

Thanks,

You are probably putting it in the wrong place.
Table Name is where you put the name of the table you are going to put the
data into.
File Name is where you put the path and name of the spreadsheet you want to
import.
I tried putting the excel path and file in the Table Name box and got the
error you described.

I'm using the Macro TransferSpreadsheet to transfer excel file to Access.
But, it keeps giving me an error that Microsoft jet engine cannot find the

[quoted text clipped - 5 lines]

Thanks,
Karie

 

[Karie M. via AccessMonster.com]

Actually, there is a folder named Docs on my c: drive. C:\docs is a valid
name. There is also a path named c:\documents and settings\my documents.
Seems like no matter what path I type the path always goes back to c:
documents and settings/my documents and then states that it can't find it.

I'm using Access 2003, Windows XP.

Thanks for any help with this. I'm stumped.
Danielle

If it is trying to chnage c:\docs to c:\documents and setting\my documents,
that sounds like it it trying to translate from short file names to long.
What version of Access and what version of Windows are you on?

I discovered something else. When I change the path to c:\docs, it gives me
the error that it can't find c:\documents and setting\my documents . It as

[quoted text clipped - 15 lines]

 

[Klatuu]

Try changing the name of C:\docs to something else to see if Windows is
getting confused over the short file name thing.

Actually, there is a folder named Docs on my c: drive. C:\docs is a valid
name. There is also a path named c:\documents and settings\my documents.
Seems like no matter what path I type the path always goes back to c:
documents and settings/my documents and then states that it can't find it.

I'm using Access 2003, Windows XP.

Thanks for any help with this. I'm stumped.
Danielle

If it is trying to chnage c:\docs to c:\documents and setting\my documents,
that sounds like it it trying to translate from short file names to long.
What version of Access and what version of Windows are you on?

I discovered something else. When I change the path to c:\docs, it gives me
the error that it can't find c:\documents and setting\my documents . It as

[quoted text clipped - 15 lines]

Thanks,
Karie