|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Mar 19th, 2002, 07:53 PM
|
#1 |
|
Board Regular
Join Date: Mar 2002
Posts: 177
|
This is a strange problem-I am trying to export some table info into Act
database. I have a table of contacts for each company. Each company can have up to 5 contacts. I need to export this data (640 records) so that the result is one long row of information, instead of multiple rows of contacts per company. For example- as it is now, by table info looks like this- Company Contact Email Phone ABC Joe joe@joe.com 555-555-5555 ABC Jill Jill@jill.com 5555555555 ABC BOB bob@email.com 5555555555 XYZ TIM tim@yo.com 5555555555 XYZ TOM sup@ohboy.net 5556668522 And I need it to export in to Excel as Company Contact1 Email1 Phone1 Contact2 Email2 Phone2 Contact3 Email3 Phone3 ABC Joe joe@joe.com 555-555-5555 Jill Jill@jill.com 5555555555 BOB bob@email.com 5555555555 XYZ TIM tim@yo.com 5555555555 TOM sup@ohboy.net 5556668522 How can I do this? Thanks |
|
|
|
Mar 19th, 2002, 07:54 PM
|
#2 |
|
Board Regular
Join Date: Mar 2002
Posts: 177
|
oops- that didnt come out the way I meant it to...
Basically, I need all the contacts in one row starting with the company name. The next row is the next company name, followed by all of the contacts... I hope that makes sense. Can this be done? Thanks |
|
|
|
|
May 21st, 2002, 05:20 AM
|
#3 |
|
Board Regular
Join Date: Apr 2002
Location: Cape Town,South Africa
Posts: 234
|
Hello friend
Maybe you were a bit unclear to us.From which program are you exporting from.And which operating system are you using ? email me personally if you want to discuss it.garethl@ij.co.za  |
|
|
|
|
May 21st, 2002, 06:32 AM
|
#4 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Newcastle, UK
Posts: 1,174
|
Quote:
The way I see it is the best way to use the data in, say, Access is to export to a NEW table called ContactInfo (or whatever) and link any tables you might have to that one. this way your not restricted to the amount for fields you have in the database. E.g. if your Database has CoName Add1 Add2 Add3 Post_Zip Contact1 Email1 Phone1 Contact2 Enail2 Phone2 etc. If your data have more than 2 contacts you need to add more fields to the database. Export the E.g. data YOU have would be a much better way to manage your data if any changes are need later on. Hope that makes sense.
__________________
"Have a good time......all the time" Ian Mac |
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
