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:[EMAIL PROTECTED] On Behalf Of Lonnie Johnson Sent: Thursday, July 20, 2006 9:31 AM To: [email protected] 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.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] ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> 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/
