[thelist] Merge two Excel databases?

Maximillian Schwanekamp lists at neptunewebworks.com
Wed Oct 27 15:49:36 CDT 2004


Theodore Serbinski wrote:

> My question therefore, is there an easy way to compare both of these 
> Excel databases and merge the data as necessary and add fields from 
> one to the other?

There's probably an easier way, but I would use a scripting language 
such as PHP or ASP to connect to the two Excel spreadsheets as 
datasources and put each into a recordset, and merge them.  
ConnectionStrings.com has examples for ODBC and OLE DB.
-- 
Maximillian Von Schwanekamp
Dynamic Websites and E-Commerce
NeptuneWebworks.com <http://www.neptunewebworks.com/>
voice: 541-302-1438
fax: 208-730-6504



More information about the thelist mailing list