I have a database with a little under 300 queries. Each of these queries returns a single number that I would like exported to an excel worksheet. Everything works perfectly until I try and import my 67th query. Then when I try to put the 67th in it produces a dialogue box with a button that says test link connection. I get the following error:



Test connection failed because [of an error initializing the provider. Unspecified Error.

Does excel or access have some kind of limit that doesn't let me insert more than 66 queries into a spreadsheet?

I am using Office 2003.

Thanks!