How to extract data in excel sheet from an external database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

Could you plz help me by letting me know how to extract data in excel sheet
from an external database?

Thanks
Regards
rkj
 
Normally one can extract data from an Excel sheet by using the File|Get
External Data|Import menu command or the corresponding VBA method
DoCmd.TransferSpreadsheet.

But I don't know what you mean by extracting data in an Excel sheet from
an external database. If the above isn't the answer, please explain.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to extract data from Jet database .db file 0
"External table not in expected format" 7
Excel Extract Text from decimal separated string 6
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Macros to extract data frommultiple workbooks to a master workbook 0
Excel How to extract the data from Excel . 0
Extracting data from Excel to Access db table 2
converting data from excel sheets to access 3

Back
Top