bb.donnay-software.com

High poster maybe, but not to be confused with high programmer. I don't even understand half the questions that are posted. Like everyone on this forum, Roger, I too have a reverence for you and your ability, and I am always amazed at the time you give for the simplest of our needs. And a personal i...

DC_Excel2Array()

Excel -> Array

"ABC-123" -> "ABC-123"
"ABCDEFG" -> "ABCDEFG"
"123456" -> "123456.0000"
"123456.0000" -> "123456.000"

I have tried to describe this problem on this forum since last month. Many others have offered suggestions and I have tried to explain why their suggestion is not the ultimate solution. You said that you demonstrated for yourself what is happening. I have not tried to describe a different problem. Y...

Your example will remove decimals, but the exposure for error exists for data that is all numeric character strings that include decimals and zeros. I have written a workaround that includes a user selection to allow decimals or not. But one dizzy clerk can ruin an inventory data file in a matter of...

I cannot upload 'xls' file.
I tried adding 'prg', 'txt', 'test' to the end, still won't take it.
I will send to your email.

I have written a workaround but it appears to me that Express is adding the zeros so it should be corrected.
Of course, I could be wrong. I was wrong twice last year.

I will send the test file to your email since I cannot upload a 'xls' file here.

Roger, I know you're busy, but when you get a chance could you look at this.
I have some users I promised a fix a month ago that are getting restless.
This is a problem in an Express function.
Thanks.

Look at 'User Contributions' topic 'Importing Excel to Dbf'.
You might get some ideas.

http://bb.donnay-software.com/donnay/vi ... ?f=7&t=238

[img]s2.jpg[/img]