Hello All,
Why does Access (2003) create indexes on importing a CSV file to a
table when using the TransferText Method in VB when the specification
name does NOT have any indexes indicated?
Similar syntax used is as follows:
DoCmd.TransferText acImportDelim, "SpecName", "TblName",
"FileNamePath", True
The specification (i.e. SpecName) has "No" indicated for indexes yet
the table created has indexes after the import is completed. A quick
look at the fields where indexes are created end with "ID", so this
may have something to do with it. Not sure but thought that I'd
mention it.
TIA!
--
Regards,
Greg Strong