[AccessD] Transfer Text Problem

Yep,
That's my preferred option every time :-)

-- 
Stuart

On 24 May 2010 at 11:22, Rocky Smolin wrote:

> 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
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>