RE: cffile parsing problem

2002-05-30 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
I think the Key word here is "ONLINE". Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: nagraj [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 11:41 AM To: CF-Talk Subject: Re: cffile parsing problem Hi

Re: cffile parsing problem

2002-05-30 Thread nagraj
Hi , If you just want to export the file to Access manually you can use import feature of Access It will ask where you follow the wizard will help you to export the text file data to Access table later you can import the data to appropriate table. Regards Nagaraj.A - Original Message -

Re: cffile parsing problem

2002-05-30 Thread Hatton Humphrey
Try treating your file variable as a list...something like: ... do whatever you need to do for each line ... HTH Hatton Seamus Campbell wrote: > Hi all > > I have a txt file (I cannot change the format) which I want to > insert/update into an access database online. > > I've bee

RE: cffile parsing problem

2002-05-30 Thread Tony_Petruzzi
#variables.newpart# Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:48 AM To: CF-Talk Subject: RE: cffile parsing

RE: cffile parsing problem

2002-05-30 Thread Andre Turrettini
You might want to start by replacing ",#Chr(10)##Chr(13)##Chr(10)##Chr(13)#" with a pipe or something. Then you can just loop thru the pipe for each line. DRE -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 8:53 AM To: CF-Talk Subject: cf