import .ATT file

26 Nov 2007 8:23 PM

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.

26 Nov 2007 10:32 PM

Daniel Pineault

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

Show quote

"mel" wrote:

> 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.

27 Nov 2007 4:56 PM

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

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

Show quote

"Daniel Pineault" wrote:

> 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
>
>
>
>
>
>
> "mel" wrote:
>
> > 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.

27 Nov 2007 6:29 PM

John W. Vinson

On Tue, 27 Nov 2007 08:56:03 -0800, mel <m**@discussions.microsoft.com> wrote:

Show quote

>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

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+Address=m***@xxxxxx.com

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]