| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import fixed width text file
The import specification works as intended when used manually (via FileGet
External Data....). But when the spec is used within a Routine the data imports into one column only. I think the error is in the syntax of TransferText. DoCmd.TransferText acImportDelim, "Tagged Transactions Import Specification", _ "RawDataImport", TextFile2Open The Help file says "...For a fixed-width text file, you must either specify an argument or ... " in relation to the specification. Any help much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixed Width Text Import Settings | Excel Discussion (Misc queries) | |||
| Automate the Text Import Wizard (Fixed Width) | Excel Worksheet Functions | |||
| Best way to import fixed-width delimited text files into an array? | Excel Programming | |||
| Automatically Parsing Fixed-width Text Import | Excel Programming | |||
| Import *.asc file into excel fixed width | Excel Programming | |||
Threaded Mode
