Access Data export to Access DB

Access Data export to Access DB

Post by Sm9l » Sun, 19 Feb 2006 04:03:28

Hi out there,
At the moment I have following situation: Data is being entered into Access
DB (2003) in one end and then weekly exported (as two tables in XML) as
e-mail attachment to other end and imported into master DB. It is then
appended into the table with same name.
My question is: how to do this more economically export only data entered
since last export, do appropriate import and how to automate the process,
export and import.
Any suggestions?

Thanks and best regards, Joe

1. XML data access or DB data access ?

2. export worksheet data to access DB

I have a price list that utilizes several dropdown boxes (via data
validation) and vlookup values. when all is said and done, I end up with a
list with a customer name, phone number, and a varied combination of options
in various sections of the worksheet, but definately in nice linear rows. My
desire is to be able to develop some method, whether through VBA or macros to
collect each option, assign it the same customer identifier and bid number
(also to be generated) and export this into an access database.

Hopefully the following example clarifies my ramblings.

customer: Smith
phone: 1234567
date: 28-August

option 1: widget blue $1.29
option 2: widget red $1.29
option 3: hoohah black $4.00
option 4: [empty]

Export Data and append to an Access table.........

custID Date Bid# item color price
1 8/28/06 200 widget blue 1.29
1 8/28/06 200 widget red 1.29
1 8/28/06 200 hoohah black 4.00

Am I dreaming??

Thanks, Brian

3. Exporting Data from MS Word to MS Access db

4. OLK2K3: Exporting Outlook field data to either Access DB or CS

5. OLK2K3: Exporting Outlook field data to either Access DB or CSV fi

6. Exporting Outlook Data to an Access DB

7. Q Exporting Outlook Data to an Access DB

8. Project Export to Access DB missing data

9. Exporting specific SQL data to a text file or Access DB on a given FTP site

10. Exporting Data From One Access DB to Another

11. Export to another Access DB and delete what was exported?

12. accessing data in an access db

13. Error Msg: "There is no Original data to access" with MS Access db

14. Accessing data from an MS access db from an Oracle UNIX server