import

G

Guest

I have a text field in which I am importing 1021245 (excel
file). But, it comes thru as 1.02125e+006. This only
happens if the excel sheet has manu rows. The data comes
thru as 1021245 when there are less rows..

STUMPED!!!
 
M

Marshall Barton

I have a text field in which I am importing 1021245 (excel
file). But, it comes thru as 1.02125e+006. This only
happens if the excel sheet has manu rows. The data comes
thru as 1021245 when there are less rows..
Click to expand...


As I said in your other thread, this is usually a formatting
issue.

I guess it could also be a problem in the Excel end, but I
don't know what might cause that. Check to see if there is
a row with a funny value (number too big, text, etc).
 

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

Importting incorrectly 1
Cell data entering slow! 0
Excel --> Word 4
Merging from an Excel file with graphics 1
Mis-performing MP4 files in Mac PPT 1
Need Help with a VBA subroutine 0
Mail Merge Directory Conditional Page Break 0
import spreadsheets (column names not always on the first row) 0

Top