New User

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I apologize in advance if this is a dumb question. I have created an
information sheet in excel that my bank uses. We need to track new accounts.
Each day, the bankers email the information sheets to me where i open the
excel sheet and enter the information onto the system. I need to create an
Access program that reads the required fields, i.e. account number, dollar
amount, customer name, etc. I have figured that out, but each time i have
tested it, the previous entry disapears. How do i save each name, so that
each new account that comes into my email box, it will save and track them?
Is this possible?
 
Conceptually what you want to do is:

have a table in Access: tblTransactions

have a set of transactions in an excel datasheet (TransactionSet)

Take the TransactioSet and ADD it to tblTransactions

It sounds as if you are 'importing the excel spreadsheet' which will create
a new table each time, overwriting the old data.

Somewhere in the process you will need to have an append query that Adds
records to the tblTransactions from some datasource, either the excel
spreadsheet or a temporary table created from the excel spreadsheet.

Sorry can't be more help without more specific information.

Ed Warren.
 
I just wanted to add that no question is stupid. You don't have to apologize.
This message board regularly sees easy questions that our experts answer
almost right away, and REALLY difficult questions that take several posts.
Access is hard when you first begin to learn it. Don't feel bad if you have a
question you think may seem easy. Just remember that many of the folks
answering your questions have been using Access for years and have become
experts. In their answer, they may make your question look a lot easier than
it is.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor
 
Back
Top