[AccessD] exporting one to many tables into flat file

[John R Bartow]

It really feels like I'm creating one of those nightmare spreadsheets that
some secretaries come up with.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Susan Harkins
Sent: Monday, March 20, 2017 6:20 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] exporting one to many tables into flat file

I might be really off base, but could you export the appropriate query to
Excel first, and work from that file instead? 

Susan H. 


I have one option. Create a csv with stated fields:  
Record ID, first name, last name, first and last name, prefix, suffix,
title/role, department, background, organization name, Home address line 1,
Home address line 2, Home address line 3, Home city, Home state/province,
Home postal code, Home country, Work address line 1, Work address line 2,
Work address line 3, Work city, Work state/province, Work postal code, Work
country, Postal address line 1, Postal address line 2, Postal address line
3, Postal city, Postal state/province, Postal postal code, Postal country,
Other address line 1, Other address line 2, Other address line 3, Other
city, Other state/province, Other postal code, Other country, Home phone,
Home phone extension, Fax phone, Fax phone extension, Mobile phone, Mobile
phone extension, Pager phone, Pager phone extension, Work phone, Work phone
extension, Work Email, Personal Email, Other Email, Work IM, Personal IM,
Other IM, Work Website, Personal Website, Other Website, Contact Tag List,
Contact Tag 1, Contact Tag2, Contact Tag3, Contact Tag4, Contact Tag5,
Contact Tag6, Contact Tag7, Contact Tag8, Contact Tag9...



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com