Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Uploading data from Excel to Access
I'm having a situation and hopefully someone can help me out
I have this database that user will upload text files and from a form, it generates an excel sheet. The database looks at an excel sheet template I made and then adds the data and renames teh sheet.the fields in the excel sheet are as follows: Name Column CDI ID A Date B ORG C Sub Inventory D LOC E CVC Part # F Serial # G CableDataBox Status H Opr ID I Corp J Account # K Coordinator ID L CDI Comments M Coordinator Comments N column a-k are the data that is from the database. L-M are the columns that the user will have to fill in, with column M being a drop down there are 5 options in the drop down, 1.Barcode Identity Issue 2.Pending research 3.Logistic asset validated 4 No trouble Found 5.Missed Issues Now, the sheet varys in rows and different dept in my company will work this sheet, not all at once and not in a week. One dept may work they half one day and the other a week later. This is where I need the help Once the dept completes it work, they email the dept head to upload the data to the database. I have a command button that will upload the data onto another database. I dont' want that. I need it to take a look at columns M, seeing if it "filled in" 1. if it not filled in and user press the upload button, nothing should be upload 2. if M has a comment and it is Logistic Asset Validated, then it be uploaded and deleted from the sheet 3. If M has a comment and it is any other comment, then it should be uploaded but not deleted and if user changes comment later on and presses upload, warning screen should appear, asking if they want to replace the same row with new comment Also, when data is uploaded, it shouldn't go to another table but to the table where the data came from. what i mean is that the table in access is called CDI IMPORT_DETAIL and fields a CDI ID (Autonumber) Date (text) Corp (text) Account # (text) Org (text) Locator (text) SubInventory (text) Box Status (text) Serial Number (text) Part # (text) Operator ID (text) Date of Oracle Import (date/time) Coordinator ID (text) CDI Comments (text) Coordinator Comments (text) Date file Uploaded (date/Time) The last 4 column of the table should be the only thing that is being filled in. So from teh excel sheet, i just need column L-M to be uploaded. And the way it looks at the access table to see what row it should update is column A, CDI ID (which is a Unique Key) Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Uploading data to an Ingres Db from excel | Excel Discussion (Misc queries) | |||
Automatic comparison and uploading of data among 2 spread sheets | New Users to Excel | |||
uploading excel data to sql | Excel Programming | |||
Extracting Excel data and uploading to access | Excel Programming | |||
Uploading data from .xls to .mdb (and not from .mdb to .xls) | Excel Programming |