pivot table from access database

S

scotiajoe

Hopefully a simple one.

I'm trying to create a pivot table in Excel 2002. I use the Pivot
table wizard, select my odbc datasource, pick the 2 fields I want data
from and get this error when I click finish:

Invalid bracketing of name '8'.

I have no idea what this means, I can't get any farther. Any ideas?
 
D

Debra Dalgleish

What are the names of the two fields?
Hopefully a simple one.

I'm trying to create a pivot table in Excel 2002. I use the Pivot
table wizard, select my odbc datasource, pick the 2 fields I want data
from and get this error when I click finish:

Invalid bracketing of name '8'.

I have no idea what this means, I can't get any farther. Any ideas?
Click to expand...
 
S

scotiajoe

two field names are:
yymm
tothrs

I tried creating a pivot table on two other Access databases an
receive the same error. Then I tried simply running a query off of th
Access databases with MSQuery (part of Excel) and the same message i
displayed on any Access database and table I pick.

I can query these databases fine with crystal reports. It ha
something to do with msquery. Any ideas
 
S

scotiajoe

Figured it out, in case anyone is interested. The directory path to my
Access database had a period (.) in it. Apparently MSQuery isn't a fan
of periods, it interferes with the "table.field" syntax. Thanks for
trying and Happy Holidays!
 
Top