Import from Notepad delimited text

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.

On 20.03.2010 18:01, ferde wrote:
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 --

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

"Stefan Hoffmann" wrote:

On 20.03.2010 18:01, ferde wrote:
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 --
.

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.

"ferde" wrote:

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

"Stefan Hoffmann" wrote:

On 20.03.2010 18:01, ferde wrote:
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 --
.

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

ferde wrote:
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.

"ferde" wrote:

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

"Stefan Hoffmann" wrote:

On 20.03.2010 18:01, ferde wrote:
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 --
.

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

"John Spencer" wrote:

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

ferde wrote:
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.

"ferde" wrote:

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

"Stefan Hoffmann" wrote:

On 20.03.2010 18:01, ferde wrote:
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 --
.

.

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 problem
I have seen often:

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


mfG
-- stefan --

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk Custom Pipeline for Splitting Messages
http://www.eggheadcafe.com/tutorials...ipeline-f.aspx