Merge excel files

May 08, 2007 4 Replies
D

I had received my database in Excel Format containing @ 30,000 item entries. I imported it in the database. Now I have received another excel file with @



1000 item entries which have been updated. So these 1000 item entries need to be overwrite the same items in 30,000 item database.

How could I do it? Is there a function in Excel which would do it. Then I can just import the updated Excel in the database.



Thanks


Vote
Twitter Facebook LinkedIn
M

Hi Don:

Are you interested in any custom solution to update the excel data to DB, if so plesae drop a email for more information.

Regards, Manic manic snipped-for-privacy@yahoo.com

"D> I had received my database in Excel Format containing @ 30,000 item entries.

Vote
Twitter Facebook LinkedIn
A

Retail Realm has an import utility with a catalogue feature. This allows update to existing items as well as changes and addition of new items. For more information contact me.

Vote
Twitter Facebook LinkedIn
T

Send me an e-mail. It won't be very hard.

Tom

Vote
Twitter Facebook LinkedIn
J

Hi.

We use for this purpose MergeExcel

formatting link
By means of this software it is possible not only to merge files Excel, but also to edit them directly in the analysis cube and to export the data back to initial files.

------------------------------------- =?Utf-8?B?TWFuaWNrYXZlbA==?= wrote:

##-----------------------------------------------## Newsgroup Access Courtesy

formatting link
Tax and Accounting Software ForumsWeb and RSS access to your favorite newsgroup - microsoft.public.pos - 34739 messages and counting! ##-----------------------------------------------##

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required