[AccessD] Transfer Text Problem

Well, I'm in the thick of sorting out the field into the PO Header, Detail
and Vendor tables.  The transfer text would have been convenient but it
turns out that reading in the line and using the Split function to separate
the fields into an array, is as, if not more, convenient.

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Monday, May 24, 2010 11:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Transfer Text Problem

OK, how about if you just concatinate on a standard file to the front of the
real file with the column headings the way you want and maybe a couple dummy
records. then you run your standard import. The column headings in the file
will end up in the data file where you can just delete them along with the
dummy records with a delete query. I suggest you have dummy records because
the import will sometimes look at those first couple records to validate the
import. Maybe not if you are going into a file that already exists.

GK

On Mon, May 24, 2010 at 10:33 AM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:
> Yeah, I was hoping to avoid that.  If I open the file as text, at that 
> point I can just process it into the PO Header and Detail tables field by
field.
> I'm going to have to do that anyway after I get the stuff transferred 
> into the import table.
>
> Thanks
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
> Sent: Monday, May 24, 2010 8:27 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Transfer Text Problem
>
> Open the file as text and read correct the first record to any field 
> name you want and then write it back out before importing.
>
> See Seth Galitzer's FIle IO code here
>
> http://seth.galitzer.net/files/download/file_io.txt
>
> GK
>
> On Mon, May 24, 2010 at 9:45 AM, Rocky Smolin <rockysmolin at bchacc.com>
> wrote:
>> Dear List:
>>
>> I have to import a CSV file with field names.  I did a manual import 
>> first to get the import table created.  Problem is that one of the 
>> columns in the CSV file has the name "P.O. Good Thru Date" and that 
>> gets created in the table as "PO Good Thru Date".  Period is an 
>> invalid character in a field name in an Access table.
>>
>> So when I try to do the import using TransferText I get an error 
>> message saying the field doesn't exist.  Which of course it doesn't.
>>
>> The CSV file is an export from Peachtree so I don't think the user 
>> has the option of changing the field name in the first row of the CSV
file.
>>
>> Is there a programmable way around this?
>>
>> MTIA
>>
>>
>>
>> Rocky Smolin
>>
>> Beach Access Software
>>
>> 858-259-4334
>>
>> www.e-z-mrp.com <http://www.e-z-mrp.com/>
>>
>> www.bchacc.com <http://www.bchacc.com/>
>>
>>
>>
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>>
>
>
>
> --
> Gary Kjos
> garykjos at gmail.com
>
> --
> 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
>



--
Gary Kjos
garykjos at gmail.com

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