Transfer from Excel pathway

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

Hello
I am trying to use macros to pull in data from excel. I do
not want to use code as I do not know anything about it
and prefer to use the simple macros that are provided in
the Access macro section...

Trying to pull in data from excel to an empty table I
created with all the headers being the same. My pathway
is the following...
(C:\saleshistory\[2003Sales.xls]Sheet1)

In the macros, it prompts me to put in the pathway which I
do as stated above in the 'File name' section.

When i run it, an error message pops up and tell me if I
have the correct pathway and file name in...

I know that I do since I went to the excel file and
put "=Cell("filename") in one of the cells and it kicks me
out the pathway as you seen above. I copy that and pasted
it into the macro section. Still errors popping up.

What am I doing wrong???
 
The path and file that are used in filename should not include the sheet
name. You enter that in the Range argument.

Path and File should be like this:
C:\saleshistory\2003Sales.xls
 
What about the sheet#?
I wanted to pull in sheet3..

how would it work then?
-----Original Message-----
The path and file that are used in filename should not include the sheet
name. You enter that in the Range argument.

Path and File should be like this:
C:\saleshistory\2003Sales.xls
--

Ken Snell
<MS ACCESS MVP>

Hello
I am trying to use macros to pull in data from excel. I do
not want to use code as I do not know anything about it
and prefer to use the simple macros that are provided in
the Access macro section...

Trying to pull in data from excel to an empty table I
created with all the headers being the same. My pathway
is the following...
(C:\saleshistory\[2003Sales.xls]Sheet1)

In the macros, it prompts me to put in the pathway which I
do as stated above in the 'File name' section.

When i run it, an error message pops up and tell me if I
have the correct pathway and file name in...

I know that I do since I went to the excel file and
put "=Cell("filename") in one of the cells and it kicks me
out the pathway as you seen above. I copy that and pasted
it into the macro section. Still errors popping up.

What am I doing wrong???
Click to expand...


.
Click to expand...
 
There is a Range argument for TransferSpreadsheet. You specify the sheet
name there.

--

Ken Snell
<MS ACCESS MVP>

Maxwell said:
What about the sheet#?
I wanted to pull in sheet3..

how would it work then?
-----Original Message-----
The path and file that are used in filename should not include the sheet
name. You enter that in the Range argument.

Path and File should be like this:
C:\saleshistory\2003Sales.xls
--

Ken Snell
<MS ACCESS MVP>

Hello
I am trying to use macros to pull in data from excel. I do
not want to use code as I do not know anything about it
and prefer to use the simple macros that are provided in
the Access macro section...

Trying to pull in data from excel to an empty table I
created with all the headers being the same. My pathway
is the following...
(C:\saleshistory\[2003Sales.xls]Sheet1)

In the macros, it prompts me to put in the pathway which I
do as stated above in the 'File name' section.

When i run it, an error message pops up and tell me if I
have the correct pathway and file name in...

I know that I do since I went to the excel file and
put "=Cell("filename") in one of the cells and it kicks me
out the pathway as you seen above. I copy that and pasted
it into the macro section. Still errors popping up.

What am I doing wrong???
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top