Field returns error when I import Text Files to Access

[geng]

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!

[geng]

I also tried Data Type as "Single" but it still returns error.

[ConneXionLost]

Try an intermediate step.

Open your text file.
Ctrl-A
Ctrl-C
Open Microsoft Excel
Ctrl-V
Ctrl-S

Now import the Excel file into Access.

Cheers,

[TheShabz]

or treat everything as text and then change to what you need in the design view of the table after import.