Automate data entry from sources

[James Pang]

Hi,

I would like to automate the revenue data coming from
different sources into a "Revenue" Table. Please Advice.

(This is what i've done)
Step 1:
--> currently the best i can do is to imitate the FORMAT
of what the "Revenue" Table look like when exported to MS-
Excel 2000.

Step 2:
After doing so, i've to self-extract all these data from
different sources into what i called a "Consolidated Data"
(as this is full information).

Step 3:
I do an import into my database. My SECOND nightmare
Occurs, if i imported twice...the data will repeat (and
revenue will double!!). Inaccuracy of the data occurs.
***I'm thinking whether i can do a CHECK on the previous
data before they allows me to import the data***
***Any codes?***

A very thank you for your help. I really appreciate if you
can help me solve this problem. I am now deep in a hot
soup by not getting this settled.

Thanks ~!

 

[John Nurick]

Hi James,

Usually you can prevent duplicate data by creating a suitable "No
Duplicates" index in the design of your table.

For instance, if your source data includes the fields
TransactionNumber
PaymentDate
AccountNumber
PaymentAmount
a "no duplicates" index on TransactionNumber would prevent any
transaction being imported twice.

If there's no unique TransactionNumber field, you could set an index on
PaymentDate, AccountNumber and PaymentAmount, which would prevent two
identical payments being added.

 

[Guest]

Hi John,

I really appreciate your help.

For my case, i couldn't do the "No Duplicate" as these
field can contain the same data

My Scenario:

I am doing obtaining all the revenue transaction done
during a month says "December". I specially have a field
which stores the Date of Transactions[Txn Date]. All these
txn revenue date will show as "31-Dec-03"


Problems: --> however when i do another import, the
records keep on piling on each other creating many
repeated data.
The same Revenue coming from "31-Dec-03" keep repeating.
(I merely wants those revenue figure from "31-Jan-04" to
be added onto the existing ONLY)

Asking whether can i do something such as --> all the
previous records update at this date say : "31-Dec-03"
will be match with the 'Going-to-Be Imported data's DATE'
1) The import skip those similar date
2) add in the Not-similar date

Pls Advice.
&
Enlighten the sad soul of mine...

Doubtful,
James Pang

-----Original Message-----

Hi James,

Usually you can prevent duplicate data by creating a suitable "No
Duplicates" index in the design of your table.

For instance, if your source data includes the fields
TransactionNumber
PaymentDate
AccountNumber
PaymentAmount
a "no duplicates" index on TransactionNumber would prevent any
transaction being imported twice.

If there's no unique TransactionNumber field, you could set an index on
PaymentDate, AccountNumber and PaymentAmount, which would prevent two
identical payments being added.

Hi,

I would like to automate the revenue data coming from
different sources into a "Revenue" Table. Please Advice.

(This is what i've done)
Step 1:
--> currently the best i can do is to imitate the FORMAT
of what the "Revenue" Table look like when exported to MS-
Excel 2000.

Step 2:
After doing so, i've to self-extract all these data from
different sources into what i called a "Consolidated Data"
(as this is full information).

Step 3:
I do an import into my database. My SECOND nightmare
Occurs, if i imported twice...the data will repeat (and
revenue will double!!). Inaccuracy of the data occurs.
***I'm thinking whether i can do a CHECK on the previous
data before they allows me to import the data***
***Any codes?***

A very thank you for your help. I really appreciate if you
can help me solve this problem. I am now deep in a hot
soup by not getting this settled.

Thanks ~!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.