ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TypeGuessRows (https://www.excelbanter.com/excel-discussion-misc-queries/229656-typeguessrows.html)

Roland Grothe

TypeGuessRows
 
Hi guys and gals

I have a problem concerning the TypeGuessRows Registry entry.

I know that i have to set it to 0 to be sure that mixed types (stris, int)
can be imported from excel to sql without errors.

I'm doing a special import every month and every month i have to chage this
setting again. I automatically is set back to 19. I never found out why and
when this happens. Does anybody of you know a solution ?

Thanks Roland
--
The code is correct - its the syntax . . .


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com