software

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

Hi CLamar,

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

Data, get external data, new database query?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.comOne option without VBA is Data-gt;Import External Data-gt;Import data, that will
launch a wizard that will allow you to get data form an Access database.

Hope this helps,
Miguel.

quot;CLamarquot; wrote:

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

See also
www.rondebruin.nl/accessexcel.htm--
Regards Ron de Bruin
www.rondebruin.nlquot;CLamarquot; gt; wrote in message ...
gt; Can anyone suggest a method to import data from tables in Access and Import
gt; them into Excel using VBA. I need the data in Excel so I can perform a
gt; Fourier Analysis on them
gt;
gt; Thanks
Thanks, that sight helped out tremendously

quot;Ron de Bruinquot; wrote:

gt; See also
gt; www.rondebruin.nl/accessexcel.htm
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;CLamarquot; gt; wrote in message ...
gt; gt; Can anyone suggest a method to import data from tables in Access and Import
gt; gt; them into Excel using VBA. I need the data in Excel so I can perform a
gt; gt; Fourier Analysis on them
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;