Tough One For You Gurus!!!

eyal8r

Board Regular
Joined
Mar 18, 2002
Messages
179
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
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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
 
Upvote 0
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 :cool:
 
Upvote 0
On 2002-03-19 18:53, eyal8r wrote:
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

What Database are exporting to?

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.
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,560
Latest member
Torchwood72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top