importing DAT files


J

judith

I am currently opening a series of DAT files in Excel
before importing into Access. Is there any way to import
directly into Access

Thanks
 
Ad

Advertisements

N

Nikos Yannacopoulos

Judith,

Yes, there is! DAT files are just delimited text files,
and if Excel can open them so can Access.
With your database open, go to menu File > Get External
Data > Import and in the File name box type *.*, so it
will display all document types, or *.DAT, so it will
display just the DAT files. Locate your file and then
follow the text import wizzard instructions. If you
experience problems with this try to rename the .DAT file
to .TXT and do your import.

HTH,
Nikos
 
G

Guest

It seems logical but I think i am missing something.
First of all using file, get external data, import just
brings in unreadable data if I tell it that the file is
text and refuses to accept it if I tell it that the file
is Excel.I have tried running a macro but that doesnt
seem to work either.

Any other suggestions would be very welcome. Thanks
 
G

Guest

It seems logical but I think i am missing something.
First of all using file, get external data, import just
brings in unreadable data if I tell it that the file is
text and refuses to accept it if I tell it that the file
is Excel.I have tried running a macro but that doesnt
seem to work either.

Any other suggestions would be very welcome. Thanks
 
Ad

Advertisements

N

Nikos Yannacopoulos

It's really funny that Excel can open the file and Access
cannot... can you open regular delimited text files from
Access?
If it's not sensitive data, you might send me a sample
file so I can see if I can help you further (take the
removethisbit part out of the address).

Nikos
 

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

Similar Threads


Top