[AccessD] exporting one to many tables into flat file

[Stuart McLachlan]

Aaaaaaaaahhhhhh!   :-)

The bane of my life is getting data out of excel into other systems.  It's the worst possible 
thing to use an an intermediary.

-- 
Stuart

On 20 Mar 2017 at 19:20, Susan Harkins wrote:

> 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
>