Text Import / Numeric field overflow

T

Tschuß

Hi,

I have import a text file in an existing database by macro and I have
the following message "Numeric field overflow".
I have checked the format of each fields and the are absolutly similar
with my import format.

So I decide to import my text file in a new table and then I have
create a query to INSERT the complete new table INTO the correct one
and then, delete the temporary table.

My solution works but I would rather import directly in my destination
table.

Any idea about my problem ?
 

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

MS Project Import Error Row 1 Column 5 2
How to have two tables on same line? 1
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
MS Project 2016 - all tasks not showing in Calendar View 0
Generated text copies into another template 0
Creating a Search using a combo box and then creating a report. 4
Excel does not accept text format! 0
Numeric Field Overflow Error 5

Top