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

R

rkj

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
 
J

John Nurick

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.
 

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 remove external organization from Office. 0
Update several ppt documents from a single excel file 0
VBA to extract data 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Excell Otpions in office environment 0
Merging from an Excel file with graphics 1
VBA for updating Resource's ActualWork 0
Can't close old pst file 2

Top