Access vb question - importing from Excel

TheUnderTow | 10:38 Fri 14th Mar 2008 | Technology

2 Answers

Hi,

I'm trying to import data from an excel worksheet into an Access table. Unfortunately the data does not start at cel A1 but at cell A6. For some reason, when I try to define this as "Sheet1!$A$6:$A$146" the ! is converted into a $.

Any idea why and any ideas as to how to get around this would be very gratefully received!

Cheers

rar torrent password

Excel help please

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by TheUnderTow. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

kempie

Have you tried without the absolute cell references?

"Sheet1!A6:A146"

TheUnderTow

Question Author

The problem I'm having is that it is converting the ! symbol into a $. This is unfortunately cropping up whether I declare absolute cell values or not - I don't know if it's a bug on my version or not as all the forums and advice has the ! included in the code!!

1 to 2 of 2

Do you know the answer?