Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

FieldName - Written In .txt file?

Discussion in 'Information Technology' started by Wayne & Carr, Jul 28, 2006.

  1. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    Hello All

    I have to [File | Get External Data | import] a lot of DATA into a Table.
    What I would like to know is if there is a way to write in a text file .txt
    The [FieldName] for each of the fields?

    This way I do not have to edit all of the new FieldName's with the correct
    information.

    Any idea's on how this "could" be done?
    Or is it impossible?

    Thanks All;
    Wayne
     
  2. Loading...


  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Depending on whether the number/type of fields change or stay constant,
    another approach would be to create your Access table(s) as needed for good
    normalization, import your raw data to a temporary table, and use queries to
    append and update data in the permanent tables from the temporary table.

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP


    "Wayne & Carr" <noSpam@spam.net> wrote in message
    news:edt8X$ofGHA.4940@TK2MSFTNGP05.phx.gbl...
    > Hello All
    >
    > I have to [File | Get External Data | import] a lot of DATA into a Table.
    > What I would like to know is if there is a way to write in a text file
    > .txt
    > The [FieldName] for each of the fields?
    >
    > This way I do not have to edit all of the new FieldName's with the correct
    > information.
    >
    > Any idea's on how this "could" be done?
    > Or is it impossible?
    >
    > Thanks All;
    > Wayne
    >
    >
     
  4. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    Hello Jeff.

    Could you perhaps provide a link to instructions on how to do this?
    If it will make my life simplier, I am willing to try/do anything.

    Thank you for your assistance.
    Wayne
     
  5. Rick Wannall

    Rick Wannall
    Expand Collapse
    Guest

    If you're importing a text files, comma delimited, the first row just has to
    be this:

    "column1", "column2", "column3", ...

    Where column1 is the name of the first column etc. User your own column
    names. Have you seen that referred to elsewhere but haven't been able to
    get it to work for you?
     
  6. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    Hello Rick;

    When you enter in the FieldNames link you mentioned, is just
    Added them in to the top Row, it does not rename the FieldName's F1 F2 F3
    F4...

    So doing it as you have mentioned is something that I have tried in the
    past.
    This is what it does.

    F1 F2
    Unique_ID Product Title exc...

    Is there a way to replace the F1, F2 exc... FieldName's with your own?

    Take Care
    Wayne
     
  7. Rick Wannall

    Rick Wannall
    Expand Collapse
    Guest

    The place to put the list of field names ("column1", "column2" etc.) is in
    the text file you're importing, before you import it.

    One of the tabs in the import wizard gives you the option to specify that
    the first row contains field names. If you put the list of field names in
    the text field, before all data rows, you can say that you have field names
    in the file and when you import the text file access will use the names you
    supplied.

    If someone else creates the text file, ask them if they can include the
    field names in their process of creation. If they cannot, and if the names
    are static (same for every text file) then you can prepare the header line
    in your own text file somewhere, then copy and paste it into the data text
    file, before you import that text file.
     
  8. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    Thanks Rick
    I am doing some checking on the Import Wizard and the information that you
    Provided, I have "Office 2000 Pro" so hopefully it will be available in that
    version.

    Wayne

    > The place to put the list of field names ("column1", "column2" etc.) is in
    > the text file you're importing, before you import it.
    >
    > One of the tabs in the import wizard gives you the option to specify that
    > the first row contains field names. If you put the list of field names in
    > the text field, before all data rows, you can say that you have field

    names
    > in the file and when you import the text file access will use the names

    you
    > supplied.
    >
    > If someone else creates the text file, ask them if they can include the
    > field names in their process of creation. If they cannot, and if the

    names
    > are static (same for every text file) then you can prepare the header line
    > in your own text file somewhere, then copy and paste it into the data text
    > file, before you import that text file.
    >
    >
     
  9. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

  10. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    The [Text Import Wizard] seems to be broken?
    Cannot get it to show up.
    I have re-registers [msexcl40.dll] but still nothing.

    Any idea's on how to make the Wizard appear?
    Is there an option, or do I have to install it?
    From the CD?
     
  11. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    I re-applied SP3 for Office 2000
    Now I have my Wizard.

    Thanks a Bunch Ricky
    You are a life saver

    Wayne
     
  12. Rick Wannall

    Rick Wannall
    Expand Collapse
    Guest

    I'm only talking about using File, Get Data, Import. You can access the
    same functions in vb code using docmd.transfertext.

    How are you importing now, if you're not using either of these?

    Ricky?
     
  13. Wayne & Carr

    Wayne & Carr
    Expand Collapse
    Guest

    Hello Ricky.

    Prior to reinstalling SP3 of Office 2000
    I used
    File | Get External Data | Import

    When I would do this, it would only pop-up a dialog stating that the
    [Import]
    Was either "Successful (or) Not".

    When I installed SP3 for Office 2k
    I now see the [Import Text File Wizard] that you referred to.

    So everything is doing great now.

    The only problem that I am having now, is located in the post
    That I see made which is titled: [The maximum characters per row is
    65000.]

    Thanks again Ricky for all your assistance.
    As if it was not for you referring to the Text Import Wizard, I would have
    probably
    Never known about it.

    Take Care and Thank you once again.
    Wayne
     

Share This Page