Not a valid Name Problem

Hi All,



I'm currently building an Access 2003 database and I need to export the data into Excel 2003 in the form of pivot tables. I went into the data tab, created the query to pull from my database and selected create a pivot table report. The error that then pops up says " [microsoft][odbc microsoft access driver]" is not a valid name. Make sure that it does not contain invalid characters or punctuation and that it is not too long." I have no idea what to do as the data can be imported as the data it's self but not as a pivot table. I think the problem lies with the query pulling from two tables in Access. Anyway any assistance would be greatly appreciated.

Kind Regards

Bern

Hello bernie,

When using ADO with Excel, you need to set the library references needed for ADO the objects.

Setting a Reference in VBA

1. Open your workbook and then press ALT+F11 to open the VBE.
2. Press ALT+T followed by the Enter key.
3. Scroll down the list until you find Microsoft ActiveX Data Objects x.x Library.
4. Press the Space bar to select it, and press Enter
5. Press CTRL+S to save the reference in the project

Sincerely,
Leith Ross