pivot table from access database

  • Thread starter Thread starter scotiajoe
  • Start date Start date
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?
 
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...
 
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
 
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!
 
Back
Top