Import records from Access

[Milan]

Hi People,
I need to import a table from another access database into my existing database. However i the imported table to transfered to an existing table, rather then it create a new table in my existing database. I am using the Transfer database command, but i cannot get it to transfer the imported table into a specific table, it keeps on creating a new table in my database.

Failing that! if it cannot be done, then is possibile to search for a table through dao with a specific name, and extract the records into another mastertable.



Would appreciate help on this please!!!!

 

[rat_1965]

The only other way I am aware of is to create a link to the other table and do an append query. Does that help?

 

[Milan]

Probably not, the name of the Access Databases that i want to import have different names!, which keep changing as users put files into this import folder!.

 

[rat_1965]

The names of the tables the users are using changes names? How is the database made and maybe a bit more background on what you are trying to do. I import data from an outside source every hour with a date time stamp, is it something like that? Maybe database replication might work?

 

[Milan]

Here's more background!!

Basically i have a routine in my current Access database that imports Mdb attachments from Ms Outlook and saves these attachments into a importfolder called "importmdb" . The mdb's that are being imported to the "importmdb" folder can be any one 16 different types of Access database, (in other words there could be 16 differents databases being imported depending on what has been email by another user to my Outlook inbox. The databases only have one table with one record, which is different for each database being import. What i need to do is import each database into a temporary table in my access database and then process the data!.The outlook import all works fine, i have got it to the stage where i have the database files in a import folder, ready to be process, but i can't get at the records in the underlying database!.

 

[USEN]

Hi Everyone,

I've been reading SEVERAL posts where people are attempting to link Outlook to Access so that things they do in Outlook are reflected in Access. That seems easy enough.

My problems is the exact OPPOSITE. I enter names & addresses in my database and wish to have them then transfer to Outlook and certain fields automatically added to contacts for future mailings. I would have thought the process would have just been reversed; however, I can't find a "Get External Data" in the "File Menu" of Outlook. I do find an import/export option; however, there is not a selection there to import from Access.

I know this is somehow possible as the Microsoft Office Live site claims that Outlook can import/export to/from .mdb files (http://office.microsoft.com/en-us/outlook/HP052434121033.aspx?pid=CH063566561033)...at least you could with Outlook 2003...I have 2007.

Does anyone have a solution? I did find one old article that gave VBA code for use with Outlook 2000, but it stated that it was no longer supported by Microsoft so I didn't know if it would work with Outlook 2007. My version of Access is 2000, but the rest of my Office suite is 2007.

I'd greatly appreciate anyone's advice as I'm definitely not well-versed with VBA coding.

Thanks,
USEN