ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to import data from Access Database. (https://www.excelbanter.com/excel-programming/367851-how-import-data-access-database.html)

vidi[_2_]

How to import data from Access Database.
 
I need to import data from a table in access but only specific fields and
they are multiple tables i need to do this from, as each field is from a
different table.

BillyRogers

How to import data from Access Database.
 
Look at my post on 7/20/2006 "Check for Primary Key"

I'm bringing in query results from multiple access databases and saving the
results in excel.

you should also check out Ron de Bruin's website http://www.rondebruin.nl/
he has some information on connecting to access

Billy Rogers

Dallas,TX

Currently Using Office 2000


"vidi" wrote:

I need to import data from a table in access but only specific fields and
they are multiple tables i need to do this from, as each field is from a
different table.


Marcelo

How to import data from Access Database.
 
do a report in access with the information that you need and print to an
excel file,

hth
regards from Brazil
Marcelo

"vidi" escreveu:

I need to import data from a table in access but only specific fields and
they are multiple tables i need to do this from, as each field is from a
different table.



All times are GMT +1. The time now is 01:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com