How about using a recordset along with Line input. Line input requires lot of manual work to come out with the file structure....
If you can send me a mail with the attachment then i can come out with the code. best regards, Birumanand. --- portella <[EMAIL PROTECTED]> wrote: > My text file does not have field or record > delimiters; is there a way of > creating record delimiters easily? > > > > > > -----Original Message----- > From: ms_access@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf > Of Lonnie Johnson > Sent: Friday, July 21, 2006 8:06 AM > To: ms_access@yahoogroups.com > Subject: RE: [ms_access] import data from a .txt > file into Access 2002 > > > > I agree with Clauss. You don't actually have an > importable file. That is > what I meant by ou may have to massage the file > first. > > Clauss Gilbert <gilbert.clauss@ > <mailto:gilbert.clauss%40insee.fr> insee.fr> > wrote: May be a solution would be to start with > opening your txt file with > MS Word, > save it in MS Word format, then use the function > "transform text into > array". Your txt file might become more structured > and easier to import > into Access. > > -----Message d'origine----- > De : [EMAIL PROTECTED] > <mailto:ms_access%40yahoogroups.com> ps.com > [mailto:[EMAIL PROTECTED] > <mailto:ms_access%40yahoogroups.com> ps.com] De > la part > de portella > Envoyé : vendredi 21 juillet 2006 05:09 > À : [EMAIL PROTECTED] > <mailto:ms_access%40yahoogroups.com> ps.com > Objet : RE: [ms_access] import data from a .txt file > into Access 2002 > > Thank you Lonnie. > > A copy of the pdf file is enclosed (I hope the > moderator will not delete > it)From there I simply save it in txt file format > and that is the structure > that I will have to work with. > > Yes there is a logical order but it is messy. > > No there are no columns and that is part of the > problem. There is only one > column which may or may not contain several fields. > Also there is no > delimiter for the end of the record which is another > problem except that > every record begins with a rather long number. > > I hope all this does not sound incoherent and please > let me know if you need > more details. I could send you the entire daily pdf > file > > What I am trying to do I know it can be done. In > fact I was doing this for > two years until on June 9 the issuer of the pdf > report changed the format > and now the person that helped me with the original > report is no where to be > found. > > A million thanks for your time > > -----Original Message----- > From: [EMAIL PROTECTED] > <mailto:ms_access%40yahoogroups.com> ps.com > [mailto:[EMAIL PROTECTED] > <mailto:ms_access%40yahoogroups.com> ps.com] On > Behalf > Of Lonnie Johnson > Sent: Thursday, July 20, 2006 1:49 PM > To: [EMAIL PROTECTED] > <mailto:ms_access%40yahoogroups.com> ps.com > Subject: RE: [ms_access] import data from a .txt > file into Access 2002 > > Then you may have to massage the text file first. Is > it in any type of > logical order? Are there a number of columns? Are > there any spaces between > columns? Can you tell us more about the structure of > the data in the text > (pdf) file? > > portella <[EMAIL PROTECTED] > <mailto:portella%40optonline.net> net> wrote: > Thank you for your help. I have tried to do this but > my problem is that the > text file is a converted file from a pdf report. The > only delimiters are > carriage returns for each line and I don't see > carriage returns considered > delimiters, are they? Once again thank you > > -----Original Message----- > From: [EMAIL PROTECTED] > <mailto:ms_access%40yahoogroups.com> ps.com > [mailto:[EMAIL PROTECTED] > <mailto:ms_access%40yahoogroups.com> ps.com] On > Behalf Of Lonnie Johnson > Sent: Thursday, July 20, 2006 9:31 AM > To: [EMAIL PROTECTED] > <mailto:ms_access%40yahoogroups.com> ps.com > Subject: Re: [ms_access] import data from a .txt > file into Access 2002 > > In the database window choose FILE drop menu. > Then Get External Data > Then choose Import > Then a file chooser window will pop open. At the > bottom where it says file > type, choose Text Files. > Find your file and select it. > Then a simple wizard will start to help you with the > rest. > > ltportellar <[EMAIL PROTECTED] > <mailto:portella%40optonline.net> net> > wrote: > I want to populate an access 2002 table with data > from a .txt file. > Can it be done? Where can I get info to do this? > thank you > > May God bless you beyond your imagination! > Lonnie Johnson > ProDev, Professional Development of MS Access > Databases Visit me at ==> > http://www.prodev. <http://www.prodev. > <http://www.prodev. <http://www.prodev.us> us> us> > us > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million > songs.Try it free. > > [Non-text portions of this message have been > removed] > > [Non-text portions of this message have been > removed] > > May God bless you beyond your imagination! > Lonnie Johnson > ProDev, Professional Development of MS Access > Databases Visit me at ==> > http://www.prodev. <http://www.prodev. > <http://www.prodev.us> us> us > > --------------------------------- > Do you Yahoo!? > Get on board. You're invited to try the new Yahoo! > Mail Beta. > > [Non-text portions of this message have been > removed] > > [Non-text portions of this message have been > removed] > > ------------------------ Yahoo! Groups Sponsor > > > Yahoo! Groups Links > > May God bless you beyond your imagination! > Lonnie Johnson > ProDev, Professional Development of MS Access > Databases > Visit me at ==> http://www.prodev. > <http://www.prodev.us> us > > > --------------------------------- > Do you Yahoo!? > Get on board. You're invited to try the new Yahoo! > Mail === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
