Importing Tables from Access into Excel using Macros or VBA

G

Guest

Can anyone suggest a method to import data from tables in Access and Import
them into Excel using VBA. I need the data in Excel so I can perform a
Fourier Analysis on them

Thanks
 
J

Jan Karel Pieterse

Hi CLamar,
Can anyone suggest a method to import data from tables in Access and Import
them into Excel using VBA. I need the data in Excel so I can perform a
Fourier Analysis on them
Click to expand...

Data, get external data, new database query?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
G

Guest

One option without VBA is Data->Import External Data->Import data, that will
launch a wizard that will allow you to get data form an Access database.

Hope this helps,
Miguel.
 

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

Importing any excel files with any sheet name into different tables in MSAccess using code 0
Analysis Toolpak 2
Analysis ToolPaks VBA Fast Fourier Transform 3
Importing Macros into Excel 2
How to export table from outlook into ms access table? 0
importing/linking data from an Access 2003 Query to an Excel 2003 2
Not all Access queries can be imported 1
Access Subscript out of range when importing into access 2010 from excel 0

Top