Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel to change/add/delete records in Access database
I have an access database that I download from a game company. In that
database there is an Orders table which is built with their own program. I however use Excel for everything including parsing their turn results file. Currently I am working on creating the orders with validation lists and formulas along with a little VBA coding to simulate the order entry program since it very user UN-firendly. I have read some other posts about the INSERT INTO option of the database connection but after reading them I still don't know how to apply them to my situation. Specifically the Orders Table is located in SN Turn Entry Data.mdb and contains a list of orders that will be executed on my next turn. If I create those orders in Excel how would I connect to this database and change specific records. Each record contains an Empire ID#, Order Code, Priority #, and 51 fields describing the different arguments for each type of order. I would like to access this table by a combination of Empire # and Priority # and change (or add if not found) the order using data in Excel Cells. I am familiar with Excel VBA but unfamiliar with Access VBA. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Delete certain records in Excel and then Change a # in another col | Excel Worksheet Functions | |||
Extracting Records From Excel Database | Excel Discussion (Misc queries) | |||
Database records from excel templates | Excel Discussion (Misc queries) | |||
how do i delete multiple records from my database | Excel Discussion (Misc queries) |