Apr 25 2005, 10:50 PM
I have large data files that I manipulate in Access, that contain >64,000 records, of mostly single/double precision floating point numbers.
When I export these to text, Access automatically exports (for example) 4.0e-03 instead of 0.004. This stuffs up my importer in the next piece of software (Datamine).
Help tells me to use a schema.ini file, but diesn't say how.
How do I export such values to text file such that they remain as 0.004 instead of 4.0e-03 ?
Thanks for any help,
Apr 26 2005, 07:39 AM
From File on the Menu Bar go to Get External Data > Import. Change the files of type to “Text Files” and select any txt file to import. When the Import Text Wizard papers, click the Advance button. From here you can build and save a specification for your export.
May 5 2005, 01:07 AM
Well I tried that, and while it was useful in saving me time importing (not having to click Double for each field), the exporter does not give options that allow me to ensure it exports as "0.006" and not "6.0e-03" in the text file.
The text file still has 6.0e-03.
Are there any Access experts out there who can help?
May 5 2005, 07:27 AM
You need to build a Fixed Width schema.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here