I have a table in Access with defined field types eg SampleID = text. I've designed a macro using transfer text to import a csv into this table. I'm having trouble with type mismatch as it seems the macro is looking at the first ? values in the csv and deciding what field type it is??? As the first lot of data in my table is numbers it seems to think they are all numbers, and the ones with text in them are blocked out. Can I do something to make it look at the field type of the table it is being imported into. I have no problems when importing the manual way!
Macro changing field type to number
- Thread starter Oscar
- Start date
gbshahaq
Sham
- Local time
- Today, 05:57
- Joined
- Apr 21, 2004
- Messages
- 52
as you're importing a text file, you can create an Import Specification, set the field type there and reference that in your TransferText macro / script.
The only way I know to create one is to manually start an import of a text file, then hit the Advanced button, configure your import fields and "Save As".
The only way I know to create one is to manually start an import of a text file, then hit the Advanced button, configure your import fields and "Save As".
