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]> 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:[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]
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.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]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Something is new at Yahoo! Groups. Check out the enhanced email design.
http://us.click.yahoo.com/SISQkA/gOaOAA/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/
