Extract data from .mdb file

  • Thread starter Thread starter Fernando
  • Start date Start date
F

Fernando

Hello,

How can I extract an entire column from a table in a .mdb
(MS Access) file, and place it in a worksheet's column?

Thanks for your help
 
Hello,

I want to do this through a VBA macro, sorry for not
specifying before
Thanks
 
Fernando

Do what Frank said, but turn the macro recorder on first. It will show you
the syntax for

QueryTables.Add

which is the method that you will need.
 
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

Extract filtered data 1
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
VBA - retrieve data on last create named range from previous inserted named range 0
Data extract after applying a filter 1
Extract matching data from large data file (csv) 8
Can Linux extract data from .MDB file, and output to text ? 1
When extracting from column A no data 4
Data Extract from Multiple Worksheets Macro 4

Back
Top