Importing Tables from Access into Excel using Macros or VBA
 

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

Importing Tables from Access into Excel using Macros or VBA
 

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

Data, get external data, new database query?

Regards,

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

Importing Tables from Access into Excel using Macros or VBA
 

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.

"CLamar" wrote:

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

Importing Tables from Access into Excel using Macros or VBA
 

See also
http://www.rondebruin.nl/accessexcel.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"CLamar" wrote in message ...
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

Importing Tables from Access into Excel using Macros or VBA
 

Thanks, that sight helped out tremendously

"Ron de Bruin" wrote:

See also
http://www.rondebruin.nl/accessexcel.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"CLamar" wrote in message ...
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