import .ATT file

  • Thread starter Thread starter mel
  • Start date Start date
M

mel

I receive data files from a customer on a regular basis that are in .ATT
Format.
What I would like to do is import these data files into an access database.
I have tried searching in the search engines, but I am not having a lot of
luck, so I thought I would post here to see if anybody can help me please.
The sender tells me that he can only use this type of format to send me the
files, so there is no point in me asking him to send them in a different way.
I do not have a lot of experience using Access so any help would be
gratefully received.
Mel.
 
You don't give us too much to go on.

According to file-extensions.org .att is a bitmap graphics extension? What
program are they using to generate the file? What format is it? Can it be
opened in a text browser (notepad or other)? What happens if you try to open
it in Excel. Have you tried to import (File-Import) into access manually?
if you can do it manually then it can be automated.

Any chance you can post the file somewhere for us to fiddle with?

Daniel Pineault
 
Hello Daniel

The information I have found out so far is as follows:-

If the file is named POSTDATA.ATT then most likely the file contains the
results from a Web form.
I'm not sure what program they are using to generate the file, but it
definitely uses an access database, which I think is saved as HTML, but not
sure how they have done this.
The format is POSTDATA.ATT
It can be opened in notepad.
If I open it in Excel, then I have field names and data all in one line
I have tried to import it into access manually, with no luck.
I have posted the file on an old web site that I have, the address is:-

http://homepage.ntlworld.com/mel.waite

If I have used the wrong terminology for any of the above, then please
accept my apologies but I am only a beginner using access.

Regards.
Mel
 
Hello Daniel

The information I have found out so far is as follows:-

If the file is named POSTDATA.ATT then most likely the file contains the
results from a Web form.
I'm not sure what program they are using to generate the file, but it
definitely uses an access database, which I think is saved as HTML, but not
sure how they have done this.
The format is POSTDATA.ATT
It can be opened in notepad.
If I open it in Excel, then I have field names and data all in one line
I have tried to import it into access manually, with no luck.
I have posted the file on an old web site that I have, the address is:-

http://homepage.ntlworld.com/mel.waite
Click to expand...

I opened the file easily in UltraEdit - any text editor, Notepad or Wordpad,
can open it, I'd guess. It's tiny. Here's the contents of the file, edited
for privacy since it apparently contains phone numbers and email addresses:

esProjectID=15209&First+Name=mike&Last+Name=brown&Telephone+Number=0xxxxxxxxxxx&[email protected]

I'm not certain whether this is the data that you want entered into Access, or
just a pointer to the data you want entered into Access.

If it is the data, then there's probably no direct way to import the data into
FirstName, LastName, Phone fields. However it wouldn't be too hard to write a
simple VBA routine to parse it out, using & as a delimiter for the Split
function.

John W. Vinson [MVP]
 
1. I couldn't find the file?

2. Based on John's posting, do you still need help parsing the file?
--
Hope this helps,

Daniel Pineault
 
Back
Top