Re: Best way to delimit text file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a simple standard. Tab Delimited with a Header row. (the header row
solves issues when importing into Access.)

I deviate from this only when the user insists upon another format and only
when they convince me that I can't convince them.

To manually create a tab delimited file:
File | Save As
Then select "Text (Tab delimited) (*.txt)" as the "Files of type" option.



--
My handle should tell you enough about me. I am not an MVP, expert, guru,
etc. but I do like to help.


"ern" <erniedude@xxxxxxxxx> wrote in message
news:1138911674.884122.170300@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
What is the best structure for delimiting text (.txt) files in
preparation for importation to an Excel workbook ?

An example might be:

Groups of Trees that have a heigth and width

Tree1;20;50;Tree2;30;47.8;Tree3.........

Would this be an acceptable way or is there another standard ?



.

Relevant Pages

  • Re: Import Wizard dropping fields defined by Import Spec Access 2007
    ... The import specs in a couple of these tools have some "tack on" ... fields included after those fields that are included in the "standard" .csv ... You seem to be importing each text file into a new table with specific ... with CSV data. ...
    (microsoft.public.access.externaldata)
  • Re: Shutdown by power switch with MinLogon
    ... > based on Standard PC HAL, disable the Standard PC component and add ... > ACPI one (make sure to use the proper one, you can check it with TAP ... Resolve dependencies, rebuild and re-deploy the new image. ... >> Importing TA output causes the same error and I haven't tried TAP ...
    (microsoft.public.windowsxp.embedded)
  • Re: Import/Export Logs
    ... mean that you added a header row containing field names. ... fields should be manually mapped when importing. ... data into Outlook with full confidence that everything will be imported ... wizard is that it can only import to 'standard" fields. ...
    (microsoft.public.outlook.contacts)
  • Re: VBA Docmd.TransferText
    ... When you're importing to an existing table, ... source must match the field names in the destination. ... If the file does have a header row with the field names, ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • Re: import data in matlab
    ... I think it is sort of standard but i couldn't figure out how to deal with it. ... In order to do that i have to import the data separating the name of the variable from the matrix. ... Since different variables have more or less missing values i cannot do this importing them as separate vectors... ...
    (comp.soft-sys.matlab)