If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IMPORT date from text file
I have a text file that contains a field of the type 'dd-mmm-yy'
When I import, it notices it is a date/time field It does not load. It returns a conversion error. also another question. suppose it loaded. how do i write SQL of the type created '01-jan-06' and created '01-jul-06'? |
#2
|
|||
|
|||
IMPORT date from text file
What is the data type of the field in your database?
How are you importing the text file? Are you using an import specification? If so, have you explicitly declared that the field is a date field? What does a row of the input data look like in the text file? Are the fields of fixed length, or delimited? Are the dates wrapped in quotes or not. I created an mdb and put a date field in it, then created a text file with dates in the format you indicated, and they imported properly when I used an import specification but gave me an error when I tried to do it without using an import specification. HTH Dale -- Email address is not valid. Please reply to newsgroup only. "Lucio" wrote: I have a text file that contains a field of the type 'dd-mmm-yy' When I import, it notices it is a date/time field It does not load. It returns a conversion error. also another question. suppose it loaded. how do i write SQL of the type created '01-jan-06' and created '01-jul-06'? |
Thread Tools | |
Display Modes | |
|
|