Software

Ask something
Discussion Locked

Excel '97

0 helpful
5 replies

by bowjangles

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to import data from an Access database using a Microsoft query. I am retrieving the data from a Query in the database. I need to select 9 fields from the Query. When i try to import the data i get this error message: "Too few parameters. Expected 6." I was wondering if anyone knows why i get this error and how to go about fixing it. OR...maybe someone might know a better way to create a report in Excel using data from Access tables and queries.

Thanks
Justin

5 replies

by chainsawz

Hi Justin,

I use Access97 and MS Query 8.0, and haven't run into this problem, but it sounds like a compatibility issue. Go to the below url, and read MS article Q171850 - ACC: "Too few parameters" When Using Microsoft Access Data in Microsoft Query. Maybe this will hold the answer you need.

http://support.microsoft.com/support/kb/articles/Q171/8/50.asp?LN=EN-US&SD=gn&FR=0&qry=Too%20few%20parameters.%20Expected%206.&rnk=5&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97

Good luck!

This discussion is closed to new replies.