Three questions actually:
I've created and saved my spec file for importing my space delimited files, however the last column is truncating to the first letter only, when run manually or via VBA. Spec file contains 7 spaces for the field, and using an editor on the txt file shows 7 spaces present. Only first space imports however.
Secondly I cannot find the spec file (scheme.ini? not sure what's being used by access 2003) for manual editing perhaps? Does this file need to be found for moving to another location if/when database moves, or is it stored internally?
Thirdly, my files are actually *.prn files by default, and seeing as Access is picky about only allowing certain extensions as imports (a serious program flaw/oversight in my mind, especially with current OS limitations for extensions being so broad). While I could write a DOS batch file and have the VBA call that to rename them to *.txt files, is there a better/easier way to do this?
I've created and saved my spec file for importing my space delimited files, however the last column is truncating to the first letter only, when run manually or via VBA. Spec file contains 7 spaces for the field, and using an editor on the txt file shows 7 spaces present. Only first space imports however.
Secondly I cannot find the spec file (scheme.ini? not sure what's being used by access 2003) for manual editing perhaps? Does this file need to be found for moving to another location if/when database moves, or is it stored internally?
Thirdly, my files are actually *.prn files by default, and seeing as Access is picky about only allowing certain extensions as imports (a serious program flaw/oversight in my mind, especially with current OS limitations for extensions being so broad). While I could write a DOS batch file and have the VBA call that to rename them to *.txt files, is there a better/easier way to do this?
