Home

Import New Column Data into existing MS Access Database

%3CLINGO-SUB%20id%3D%22lingo-sub-368268%22%20slang%3D%22en-US%22%3EImport%20New%20Column%20Data%20into%20existing%20MS%20Access%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-368268%22%20slang%3D%22en-US%22%3E%3CP%3EHi-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20I%20have%20a%20created%20a%20fully%20functional%20MS%20Access%20database%2C%20that%20uses%20queries%20to%20append%2Farchive%2Fdelete%20items%20to%20and%20from%20Sharepoint.%20Futhermore%2C%20I%20have%20created%20a%20UNION%20query%20that%20keeps%20a%20running%20total%20of%20ALL%20items%20that%20have%20been%20passed%20through%2Fstill%20in%20my%20SharePoint%20site.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20my%20delema%2C%20recently%20I%20have%20added%205%20new%20columns%20that%20only%20consist%20of%201's%20%26amp%3B%200s%20to%20this%20particular%20project.%20Unfortunatly%2C%20all%20of%20my%20'Achived'%20records%20do%20not%20have%20the%20data%20in%20those%205%20new%20columns%20because%20they%20have%20already%20been%20pulled%20from%20the%20SharePoint%20site.%20The%20good%20news%20is%2C%20I%20was%20able%20to%20retrieve%20the%20data%20from%20a%20table%20in%20Teradata.%20Also%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20every%20day%20I%20have%20to%20do%20an%20export%20from%20my%20'Union'%20query%20in%20access%20and%20bump%20it%20up%20against%20my%20Teradata%20table%20into%20Excel%2C%20to%20get%20the%20data%20for%20the%205%20new%20columns%20into%20all%20of%20the%20records%20that%20are%20messing%20this%20data.%20This%20portion%20is%20just%20saved%20in%20a%20stand%20alone%20excel%20spreadsheet%2C%20that%20I%20save%20with%20a%20date%20stamp%20on%20it%20everyday.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20really%20want%20to%20do%20is%2C%20be%20able%20to%20append%20the%20data%20that%20is%20missing%20to%20'Union'%20query%2C%20without%20overwriting%20anything.%20So%20that%20my%20'Union'%20query%20is%20fully%20up%20to%20date%2C%20especially%20since%20I%20use%20this%20same%20query%20for%20backend%20reporting.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-368268%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-370225%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20New%20Column%20Data%20into%20existing%20MS%20Access%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-370225%22%20slang%3D%22en-US%22%3E%3CP%3EI%20got%20it%20figured%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20used%20an%20'Update'%20query.%3C%2FP%3E%3C%2FLINGO-BODY%3E
t_horne03
New Contributor

Hi-

 

  I have a created a fully functional MS Access database, that uses queries to append/archive/delete items to and from Sharepoint. Futhermore, I have created a UNION query that keeps a running total of ALL items that have been passed through/still in my SharePoint site. 

 

Here is my delema, recently I have added 5 new columns that only consist of 1's & 0s to this particular project. Unfortunatly, all of my 'Achived' records do not have the data in those 5 new columns because they have already been pulled from the SharePoint site. The good news is, I was able to retrieve the data from a table in Teradata. Also

 

So every day I have to do an export from my 'Union' query in access and bump it up against my Teradata table into Excel, to get the data for the 5 new columns into all of the records that are messing this data. This portion is just saved in a stand alone excel spreadsheet, that I save with a date stamp on it everyday.

 

What I really want to do is, be able to append the data that is missing to 'Union' query, without overwriting anything. So that my 'Union' query is fully up to date, especially since I use this same query for backend reporting. 

1 Reply

I got it figured it.

 

I just used an 'Update' query.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies