Link a access .mbd file table to a pivot table in excel.

  • Thread starter Thread starter Sinner
  • Start date Start date
S

Sinner

Hi,


How do we link a access .mbd file table to a pivot table in excel?
Also if anyone can post a simple user form for data entry in excess
table which I can begin with.
 
I think in this case it would be wise to reverse the process and start in
Excel using MS Query. From there you can access the tables you need from your
db.

You should look under create query in the data menu from Excel.

hth
 
You can create an external data source in excel that is linked to
an .mdb file. Then use those cells as the Pivot Table source data.
 
If you use thePivotTableWizard inExcel, you can specify theAccessTable
you want as your input.



--
James B Gaylord
From the Wolf Comes the Strength of the Pack
From the Pack Comes the Strength of the Wolf
                                                     - R Kipling

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200803/1
Click to expand...


Hi,

Cyberwolf, while using Pivot table wizard, at the end I get an error
message "Syntax error in FROM clause".
Any idea?

Thx.
 
Back
Top