importing .dat files


T

TT77

am having difficulty importing .dat file

it is opeing in a table file as a continuous row of data instead of creating
columns, even though it is delimited with *'s.

any suggestions?
 
Ad

Advertisements

D

Douglas J. Steele

I'm surprised you're able to import them as all: the .dat extension isn't
one of the ones that's allowed for import by default (or did you change the
registry to allow it?)

Where did the file come from? Access insists on both a carriage return and
line feed as line delimiters: some products use only a line feed. Try
importing it into Excel, which is less rigid than Access.
 
Ad

Advertisements

D

Dhaval Dave

TT77 said:
am having difficulty importing .dat file

it is opeing in a table file as a continuous row of data instead of
creating
columns, even though it is delimited with *'s.

any suggestions?
either you can have a problem .
 

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