Here's my situation. Using docmd.transferspreadsheet acimport, I'm attempting to import a spreadsheet in which column J contains currency data that is 6 decimals. Unfortunately, no matter what I do, only 4 decimal places are imported and the rest of the data is truncated.
The headings on the spreadsheet start on row 10 and the data in row 11. The worksheet is protected and we don't have the password to remove protection. All other data imports fine.
The table for import has fields named F1.....F40 with all fields as datatype text and field size 255.
Any solutions?
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Please zip all files prior to uploading to Files section.
.
__,_._,___
Tidak ada komentar:
Posting Komentar