Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Database
Folks
I have a small excel spreadsheet which I use for data entry at the end of each day. Rather than discard the previous day's data, I want to append this data to a database. * What is the quickest or easiest method to accomplish this goal ? One possibility is to be able to press a button (connected to the appropriate code) to manually transfer the data in the spreadsheet to the database. Thanks, JoJo. , |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Database
The idea of a button will work and there are lots of people around here who
can help you. The code to do it however is not terribly easy and probably not a great project for a beginner. If you are interested in proceeding the repy back with a few more details. A couple of things we will need to know are what type of database you are writting to and whether Referential Integrity is enforced on the table. -- HTH... Jim Thomlinson "JoJo" wrote: Folks I have a small excel spreadsheet which I use for data entry at the end of each day. Rather than discard the previous day's data, I want to append this data to a database. * What is the quickest or easiest method to accomplish this goal ? One possibility is to be able to press a button (connected to the appropriate code) to manually transfer the data in the spreadsheet to the database. Thanks, JoJo. , |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Database ? | Excel Discussion (Misc queries) | |||
Transforming messy database into clean database | Excel Discussion (Misc queries) |