Import an Exter Acc Tabl into an Existing Acc Tabl

Topic

New Reply

Help Please!
I need to import an External Access Table into an Existing Access table (2 seperate files). I have tried Importing External Data, but that just slaps the imported table “beside” the one I would like it Imported “Into”. I know I can import it this way, and then do an “Append Query” to incorporate its contents into the existing table, but can’t you simply “Import” it to begin with, like you would data from an Excel file? Where’s the Import Wizard in this case? It doesn’t appear like it does when I import external data from Excel?
Thank you so much anybody who has some answers

Reply | Quote

Replies

I do not know how to accomplish this with the Import Wizard, but … If you position in your external Db and write an append query, you will have the option of appending that data to a table in your existing Db. The append window has a radio button that reads Another Database and has a textbox for the complete filename (include the path).

Reply | Quote

ThomasW
Thank you for your response. Your answer makes a lot of sense, and sounds quite feasible. I do believe this is the answer…will work it out when I get back to work in the morning. My hats off to you.
Teachesms
Padgett *You are really

Reply | Quote

One screen of the import wizard also allows you to select new table or existing table for your import. If you select an existing table, it will append the records as long as they’re the same shape.

Reply | Quote

I am familiar with the screen you are referring to Charlotte, but when I looked there, that screen does not seem to display when I am importing an Access table. It only displays when I am importing other file types. What am I missing? … I’d like to learn this.

Reply | Quote

I have tried this method Charlotte. The same wizard does not show up when you are importing another table from another access database. No choices are given, except to select the table, which I do…then it just slaps it right “beside” my existing one, not “within” it like I had planned. The datatype, fields (everything) is the same, there are no conflicts there, it simply seems the wizard will not show up in the same manner as when you import a different medium, such as an Excel file like ThomasW has mentioned. But thanks a bunch anyway.
ThomasW…I tried your method and in the append query, I had a bit of a time until I tried using the Like “*” command to express the criteria. Cannot begin to thank you enough. Excellent!!!!!

Reply | Quote

Oops. You’re absolutely right. I managed to overlook the fact that you were importing an Access table. The wizard’s behavior in that instance is an example of trying to make tools too smart. It thinks it knows what you mean to do, so it goes ahead and does it without checking.

Reply | Quote

My usual procedure would be to create a link to the external DB table, and then use an append query to add the linked table’s data to the current DB’s table. This allows for a daily/weekly/etc. update or overwrite of the linked table to be imported to the main table without creating any new links or queries; just fire off the append already in place.

If this is just a one-time join, the link + append query is still a simple solution; just delete them once your update is complete and they are no longer required.

Reply | Quote

I came across this SQL code that might do the job you want. The book was using a copy of the Northwind.mdb file named Nwind.mdb. After opening the Nwind.mdb file and deleting all records in the customer table, try this code to append all the records from the Northwind.mdb customers table:

INSERT INTO Customers SELECT * FROM Customers IN “C:Program FilesMicrosoft OfficeOfficeSamplesNorthwind.mdb”;

Reply | Quote