I tried importing a text file to Access and it always gives me error on the fields 5,6,7,8.
I did the following steps:
File - Get External Data - Import
On the Import Text Wizard
Delimited - Tab(First Row Contains Field) - New Table
- Data Type
Field 1 - Text
Field 2 - Text
Field 3 - Text
Field 4 - Text
Field 5 - Date/Time
Field 6 - Long Integer
Filed 7 - Long Integer
Field 8 - Long Integer
Field 9 - Text
Field 10- Text
-Primary Key
No primary Key
Import to table
Finish
Please Help!
Thanks!