Linking Access to Excel

  • Thread starter Thread starter Rita
  • Start date Start date
R

Rita

Hi,

I have an access database that I link to Excel but when I
go to refresh data. I get the following error.
[Microsoft][ODBC Microsoft Access driver] too few
parameters. Expected 1. I have added in the drivers for
my addin toolbar. Any help would be appreciated. Thank
you
 
This is caused when a parameter query is used to run
Microsoft Query in Excel.
Try creating a table from your parameter query in Access
and using that to link into Excel. Of course, you will
have to run the make-table each time you want to refresh.
Good Luck!
 
Back
Top