Importing Tables from Access into Excel using Macros or VBA

C

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

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
 
M

Miguel Zapico

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.
 
Top