[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