Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Excel Database via Access Main Database with a script Finnbar New Users to Excel 2 November 3rd 08 08:24 PM
Delete certain records in Excel and then Change a # in another col jeannie v Excel Worksheet Functions 8 July 22nd 07 04:54 AM
Extracting Records From Excel Database thorvision Excel Discussion (Misc queries) 5 December 1st 05 07:09 AM
Database records from excel templates BeeJay Excel Discussion (Misc queries) 4 June 22nd 05 03:02 PM
how do i delete multiple records from my database AUSTINJ Excel Discussion (Misc queries) 1 May 15th 05 11:08 AM


All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"