J
JOE_UPENN
Hi,
I am running Office 2000 SR-1on a Windows 2000 SP-4 workstation.
I need KB articles etc... explaining how to merge data from several excel
workbooks into a single Access database.
These workbooks all have IP addresses as a common factor. I am attempting
to merge several list which contain printer information into a single
database. An example of this is that one Excel workbook will contain a
printer name, it's IP address and it's corresponding MS print queue.
Another workbook contains printer name, IP address and SCM print queue;
another workbook has the same printer and IP address and another print
queue. I want take all of these and put them into one database, but not
have the Printer name & IP address appear several times. It should have
printer name, IP address, followed by MS queue, then any remaining queue
that match up for the IP address during the merge.
As is evident by this posting, I have very limited interaction with Access
and Excel, I typically work on the server side...so any and all detailed
information would be greatly appreciated!
I am running Office 2000 SR-1on a Windows 2000 SP-4 workstation.
I need KB articles etc... explaining how to merge data from several excel
workbooks into a single Access database.
These workbooks all have IP addresses as a common factor. I am attempting
to merge several list which contain printer information into a single
database. An example of this is that one Excel workbook will contain a
printer name, it's IP address and it's corresponding MS print queue.
Another workbook contains printer name, IP address and SCM print queue;
another workbook has the same printer and IP address and another print
queue. I want take all of these and put them into one database, but not
have the Printer name & IP address appear several times. It should have
printer name, IP address, followed by MS queue, then any remaining queue
that match up for the IP address during the merge.
As is evident by this posting, I have very limited interaction with Access
and Excel, I typically work on the server side...so any and all detailed
information would be greatly appreciated!