Contact Info Export to Excel with Multiple Phone Numbers

[jdowding]

With a database with customer address information in one table and phone
numbers in another table to allow for a variable number of phone numbers for
each customer, is there an easy way to export information into an Excel
spreadsheet so that there is only one line per customer, with phone numbers
in columns at the end of each line?

Thanks for any help you can provide.

 

[lucky, somchai kuhn]

With a database with customer address information in one table and phone
numbers in another table to allow for a variable number of phone numbers
for
each customer, is there an easy way to export information into an Excel
spreadsheet so that there is only one line per customer, with phone
numbers
in columns at the end of each line?

Thanks for any help you can provide.

 

[John Spencer MVP]

PERHAPS, you can use a crosstab query to export the data. It depends on how
your data is set up.

Customers Table

CustomerPhones Table
CustomerID
PhoneType: Fax, Mobile, etc
PhoneNumber

If your design restricts the customer to having a maximum of one of each type
of phone, then a crosstab query should be perfectly feasible for exporting the
data. If a customer could have two or more Mobile phones, then the problem is
more complex and I don't see an easy solution.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County