Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel upload to Access (VBA help)
Hello, need some assistance. I have this access database where it grabs raw
data from an oracle database and user will upload file onto my database. Now this database will take that raw data and spit out several excel sheets, depending on location criteria. Now, these are the fields on the access database CDI ID Date Corp (location) Account # ORG Locator Subinventory Box Status Serial Number Part # Description Operator ID Date of Upload Now when the excel sheet is generated, it looks at a template sheet and adds all data and save it as a different sheet The fields on the excel sheets are as follows: Unique Number (CDI ID) Date (DATE) Org (ORG) Sub Inventory (Subinventory) LOC (Locator) CVC Part Number (Part #) Serial Number (Serial Number) CableDataBox Status (Box Status) Opr ID (Operator ID) Corp (CORP) Account # (Account #) Coordinator ID CDI Comments Coordinator Comments Now that last three fields are what needs to be filled in. The CDI Comments is a drop down. There are 5 options: BARCODE IDENTITY ISSUE PENDING RESEARCH LOGISTICS ASSET VALIDATED NO TROUBLE FOUND MISSED ISSUES I need a way to upload the data back to the table, BUT only the last 3 fields. I dont' want to upload data that I already have What I need is when the user press UPLOAD (there need to be an upload button on the excel sheet) that it looks at the 3 fields and if the drop down is blank (default), then that line shouldn't be uploaded. Only fields that should be uploaded are rows that the CDI Comments are filled. Now if the CDI COmments are to Logistic Asset Validated, then it needs to upload that line back to the table and the delete it self from the excel sheet. If the cdi comments are any other options, then it uploads but still be there so user have option to change. When the next time the user press upload and that row has already been uploaded, msgbox should appear prompting user if they want to update with new data Please help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upload an Excel file? | Excel Discussion (Misc queries) | |||
Excel data upload to Oracle | Excel Discussion (Misc queries) | |||
Data Upload from Excel to SQL Server | Links and Linking in Excel | |||
Upload Excel to Access | Excel Programming | |||
how to upload csv to excel? | Excel Programming |