Import from Notepad delimited text

F

ferde

Is it possible to import from Notepad . There is a table with pipe
delimiters that is automatically generated in a .dat text file using Notepad
which I would like to import / link into my database daily.
This .dat file arrives via email each day as an attachment. I tried saving
the .dat file into a .txt extension but ACCESS wouldn't recognize it .

I currently need to use the excel text wizard everyday to convert this file
into an .xls format . I then have my access 2003 database linking to this
..xls file. Although I know how to convert this .dat file there are others
in my office who do not. Is there a way to eliminate this conversion step
to get this .dat table linking? I'm a beginner and would appreciate any
direction.
 
S

Stefan Hoffmann

Is it possible to import from Notepad . There is a table with pipe
delimiters that is automatically generated in a .dat text file using Notepad
which I would like to import / link into my database daily.
This .dat file arrives via email each day as an attachment. I tried saving
the .dat file into a .txt extension but ACCESS wouldn't recognize it .
What do you mean with 'ACCESS wouldn't recognize it'?

Access can handle pipe-delimited text files very well. The only problem
I've seen often:

Is this .dat file a real text file, thus are the line-breaks Windows
style - CrLf?


mfG
--> stefan <--
 
F

ferde

Yes if I understand the meaning of your question the .dat file is a text file
that Windows excel text wizard converts easily but ACCESS doesnt recognize
the file

Thank you for responding
 
F

ferde

Sorry I didnt see your initial question .

I get a message when I try to import or link to this file that says
Access could not find the object. That is what I meant when I said Access
doesnt recognize it.
 
J

John Spencer

If I remember correctly, I had a similar problem and found that I had to
rename the file by changing the extension from DAT to TXT. Once I did that I
was able to import the file. Actually, I was a timid soul and a copied the
file using the FileCopy function and renamed it. Roughly the call was like:
FILECOPY "D:\\SomeFolder\MyData.dat","D:\\SomeFolder\MyData.txt"

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
F

ferde

I was able to rename the document.dat file to a document.txt and I can open
the file using notepad as well as excel and I can see the pipe delimiters
between the columns.

The document.txt is in the same folder as the ACCESS.mdb but when I try to
import I still get the message that ACCESS doesn't see the object and to
check my path and make sure the file exists. I'm not sure what I am doing
wrong because I can import the same document if it is converted into an .xls
format. mmmmnnn
 
J

John W. Vinson

The document.txt is in the same folder as the ACCESS.mdb but when I try to
import I still get the message that ACCESS doesn't see the object and to
check my path and make sure the file exists. I'm not sure what I am doing
wrong because I can import the same document if it is converted into an .xls
format.

How are you initiating the import? If you're doing it from code you may need
to provide the full drive/path/filename, in quotes:

"C:\My Documents\ProjectX\wxyz.txt"

If you're using File... Get Extenal Data... Import, and choosing Text as
"files of type", and navigating to the file, I'm perplexed.
 
R

Renamer File

Yes if I understand the meaning of your question the .dat file is a text file
that Windows excel text wizard converts easily but ACCESS doesnt recognize
the file.

<a href="http://www.ulfwood.net/RenameFiles/FileRenamer.aspx">Rename Files</a>




Stefan Hoffmann wrote:

On 20.03.
20-Mar-10

On 20.03.2010 18:01, ferde wrote
What do you mean with 'ACCESS would not recognize it'

Access can handle pipe-delimited text files very well. The only proble
I have seen often

Is this .dat file a real text file, thus are the line-breaks Window
style - CrLf

mf
--> stefan <--

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk Custom Pipeline for Splitting Messages
http://www.eggheadcafe.com/tutorial...6-241d5e325f42/biztalk-custom-pipeline-f.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top