| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Access and Oracle | Excel Discussion (Misc queries) | |||
| Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
| Importing data from Access into Excel: prob w/ cutting off fields | Excel Worksheet Functions | |||
Hybrid Mode
