Import date/time field from text file creates numeric overflow

M

Maer

When I attempt to import or link a text file in Access that has a long
date/time field i.e. 01/06/2005 09:19:05 AM it shows up correctly when
setting the import specs but then shows numeric overflow when you open the
table (NUM#!) Any ideas?

Thanks!!! Mare
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking table gets numeric field overflow 2
*@!? Numeric Field Overflow 2
Import from Linked Spread Sheet In Access 1
Problem formatting dates from CSV file 2
Numeric Field Overflow Error 5
Importing Fixed Length File into Access 2007 1
Numeric Field Overflow 1
Type Conversion Failure importing number as text 1

Top