largeselection
Active Member
- Joined
- Aug 4, 2008
- Messages
- 358
So I have a connection which is created in VBA to a text file that I have saved somewhere. I just found that there are a bunch of rows which have 0s for a certain column, but have decimals for the majority of the rest of the rows (0.5,0.6,etc), but when it creates the connection in VBA, the max rows it scans are 8 (I set that to keep it quick), so it thinks that column is "integers" so everything comes back as 0s. I need that to come back as Float so that I can get the decimals, but the only way I know how to do that is to create a Schema.ini file so that when it imports, it does it according to the schema. Is it possible to do this in vba directly? Either something that would tell excel that the schema for that entry = float or something that will open or create a schema file and adjust it so that it changes Integer to Float?
Sorry if I'm not being clear, please ask any questions you may have and thanks for your insights!
Sorry if I'm not being clear, please ask any questions you may have and thanks for your insights!