J
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 ~!
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 ~!