1. Home
  2. Point-Of-Sale Software
  3. Merge excel files

Merge excel files

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

Reply to
Donwatane
Loading thread data ...

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.

Reply to
Manickavel

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.

Reply to
Afshin Alikhani

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

Tom

Reply to
Terrible Tom

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! ##-----------------------------------------------##

Reply to
John

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.