Access 2007 Import text file

L

lepird

Hi,

in Access 2003 I was able to write Import Specification to import text file
into Access (table). Text file had fix width and some of fields were Date
fields in format YYYYMMDD.
I tried to do the same with new Access and it didn't work. The type
conversion occured. I now I could import dates as text field and later write
a little code to convert it into date type, but is there any easier (direct)
way to do it? Maybe I'm missing something.

Tahnk you for any suggestion you post here.
 

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

Top