[AccessD] exporting one to many tables into flat file

[John R Bartow]

I'm not but I feel your pain.

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

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
> 


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