Official NolaZcc Thread
Any access/excel wizzes here?
I will explain my situation and my goal in hopes that someone can walk me through this step by step. I have watched several tutorials and im still pretty confused.
I built a table in Access with several field names. Solders last name, first name, SSN, DOB, entrance to the army and lots of other things. I exported the entire table to an excel spreadsheet. here is where my questions come in.
1. I want to make the table in excel auto update and mirror the table i have in access, every time i open it in excel. (the reason is i need to do several formulas with certain information that i cannot do through access's queries)
2. I want to make another sheet (sheet2) in excel that only has certain columns from sheet1. The columns I want on sheet2 are not side by side in sheet1 though. I want the data (rows) in sheet2 to be linked to the table in sheet1 so if i add a new record in access, it is updated to the table (sheet1) in excel and the data in the selected columns also added to sheet2.
for instance, in access, i add a new soldier and all of his information into the database. I open excel and the new soldier's info is auto updated into my sheet1 table which contains every field name from the table in access. I then click on sheet2 in excel, which only shows column D, G, K, L, F, P, Q, AE, and AF from sheet1, as well as some added columns which contain formulas that compute data from those columns. I scroll down sheet2 and this new soldiers info (which was entered initially in access) is also found in the excel sheet1 and sheet2.
This must be an easy task to complete. Everything I find is 100 times more advanced than what im actually trying to do here.
Thanks in advance....
I will explain my situation and my goal in hopes that someone can walk me through this step by step. I have watched several tutorials and im still pretty confused.
I built a table in Access with several field names. Solders last name, first name, SSN, DOB, entrance to the army and lots of other things. I exported the entire table to an excel spreadsheet. here is where my questions come in.
1. I want to make the table in excel auto update and mirror the table i have in access, every time i open it in excel. (the reason is i need to do several formulas with certain information that i cannot do through access's queries)
2. I want to make another sheet (sheet2) in excel that only has certain columns from sheet1. The columns I want on sheet2 are not side by side in sheet1 though. I want the data (rows) in sheet2 to be linked to the table in sheet1 so if i add a new record in access, it is updated to the table (sheet1) in excel and the data in the selected columns also added to sheet2.
for instance, in access, i add a new soldier and all of his information into the database. I open excel and the new soldier's info is auto updated into my sheet1 table which contains every field name from the table in access. I then click on sheet2 in excel, which only shows column D, G, K, L, F, P, Q, AE, and AF from sheet1, as well as some added columns which contain formulas that compute data from those columns. I scroll down sheet2 and this new soldiers info (which was entered initially in access) is also found in the excel sheet1 and sheet2.
This must be an easy task to complete. Everything I find is 100 times more advanced than what im actually trying to do here.
Thanks in advance....
Registered User
Joined: Jan 2009
Posts: 350
Likes: 0
From: New Orleans
man i love the swang n bang guys cars, (it is a little too much camber for me tho)
i need spacers soon so i can run at least +2 and -3
it sucks cus ima have to raise my car around .4 inches, drove to br yestereday and almost ****ed my car up on all the **** i bottomed out on, i wish i could safely ride as low as them
i need spacers soon so i can run at least +2 and -3
it sucks cus ima have to raise my car around .4 inches, drove to br yestereday and almost ****ed my car up on all the **** i bottomed out on, i wish i could safely ride as low as them
New Member
Joined: Oct 2007
Posts: 1,688
Likes: 0
From: New Orleans
Last edited by 504Z07; Dec 17, 2009 at 07:54 AM.