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?

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

Thanks,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"John" wrote:

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?

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" wrote in message
...
I, for one, don't know what you are talking about. Can you please
describe
the scenario in more detail?

Thanks,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"John" wrote:

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?

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/...batextimportwb

If importing from Access to Excel:
http://www.erlandsendata.no/english/...badacimportado

If importing from Excel workbook (to another Excel workbook):
http://www.erlandsendata.no/english/...dacimportwbado



HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"John" wrote:

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" wrote in message
...
I, for one, don't know what you are talking about. Can you please
describe
the scenario in more detail?

Thanks,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"John" wrote:

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?