Hi, When pasting your example data on a computer with an european setting for currency I get an error. Fix: Remove dollar sign from [CreditLimit] and just have a clean number. We use commas instead of points to separate decimals from integers so, for example, [5,000.00] will end up as 5 on my computer. Fix: edit data to just say [5000]. Same problem with commas vs dot on the percentage data where, for example, [0.2] will end up as [200%] on my localized computer. Fix, change data to [20%] in the copy/paste data. I understand that the format will not look exactly like a text file export, but it will have extended compability with localized versions.
Reply from Alex Hedley:
Are you copying from the Table or Form?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.
