Get External Data returns error message

[John]

I have 8 different workbooks that each have a worksheet called CommissionDB.
I would like to periodically update those 8 worksheets from a master
database called Master.xlsm. I tried doing a "get external data/from other
sources" from within the 8 workbooks, but get an error message "too few
parameters". Suggestions please?

 

[ryguy7272]

I, for one, don't know what you are talking about. Can you please describe
the scenario in more detail?

Thanks,
Ryan---

 

[John]

Maybe I explained in too much detail. Basically, I'm trying to get external
data from an Excel range in another workbook by clicking:
Data
Get External Data
From Other Sources
From Microsoft Query
Excel File
(Point to the file)
Then I get an error message:
"too few parameters"

 

[ryguy7272]

Are you using Excel 2007 and Access 2007? Importing to Excel from Access?
Take a look at this John:
http://support.microsoft.com/default.aspx/kb/171850

ADO would probably be better for you:
http://www.erlandsendata.no/english/index.php?d=envbatextimportwb

If importing from Access to Excel:
http://www.erlandsendata.no/english/index.php?d=envbadacimportado

If importing from Excel workbook (to another Excel workbook):
http://www.erlandsendata.no/english/index.php?d=envbadacimportwbado



HTH,
Ryan---