See comments in-line.
--
HTH
Van T. Dinh
MVP (Access)
Brenda said:
I am just trying to get something to work. So now I have tried many different
things. I have several txt files in comma delimited format with "" around
text fields. I can not get the file to import and obviously my access is
limited. My first attempt to get the data loaded to a table was to create
the table in a query and then import the data. When that did not work then I
tried letting the Import Wizard create the table thinking that would import
the records. Just trying to get the text file imported any way possible.
The double-quotes will be a problem. I don't think you can have
double-quotes for some Text Field values and no double-quotes for some other
Text Field values.
The timestamp does not have "". Do you think I can still import it as text
and then manipulate it? These files are really large, like 608mb. I know
foxpro well and could write a foxpro program to strip the dates of the
.sssssssss. But I was trying to do it in Access.
Try just linking the CSV file to Access rather than importing. Access will
guess the data types and see what it comes up with the date/time text in the
format "yyyy-mm-dd hh:mm:ss.ssssssss". If it comes up with DateTime or /
Text data type, you can then use Create Table Query (for a new Table) or
Append Query (to an existing Table) with String manipulations if require to
create these Records in the final destination Table.
So, a different question. Ccan you specify the length of a text field in the
Import to new table? Just curious that I can not find it as an option.
I don't think so. OTOH, I always create the Table Structure first before I
import.