My text file does not have field or record delimiters; is there a way of creating record delimiters easily?
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lonnie Johnson Sent: Friday, July 21, 2006 8:06 AM To: [email protected] 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 --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click. <http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/q7folB/TM> yahoo.com/SISQkA/gOaOAA/yQLSAA/q7folB/TM ----------------------------------------------------------~-> 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 Beta. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] 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/
