Welcome to SPN

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

Sign Up Now!

Re: load an alpha/numeric field into access from a text file

Discussion in 'Information Technology' started by tina, Oct 27, 2005.

  1. tina

    tina
    Expand Collapse
    Guest

    well, frankly, it sounds pretty strange to me too. i don't know if the
    origin of the text file being SQL Server makes a difference - i wouldn't
    have thought so. re the Import Specification: i'm not talking about the
    table's design view. when you click File | Import | Get External Data from
    the database window, the Import Wizard dialog box opens. you can click on
    the Advanced button in the lower left corner of the dialog. in the Advanced
    options window, you can designate the data type of each field being
    imported. then save your settings as an Import Specification for use in
    future imports of the data, so you don't have to re-invent the wheel each
    time.

    try that, and if it doesn't work, then my only other suggestion is to open
    the text file in Excel and look at the column of data that you're having
    trouble with - including moving from cell to cell in that column so you not
    only see the "display" values but also the "real" values. maybe there's
    something odd about the data and maybe you can fix it by highlighting the
    column in Excel and explicitly formatting it to Text. then you could resave
    the text file, or save it as an Excel file (or both), and try the Access
    import again.

    hth


    "Red" <Red@discussions.microsoft.com> wrote in message
    news:936F6362-230E-41F2-97E6-61CDAB704F1D@microsoft.com...
    > The first value is a number. I have replaced it and the next 7 with a text
    > entry (ie:SSS). Made no difference. Still created the error table with

    'type
    > conversion error and those table fields were blank. -- If I'm

    understanding
    > your reference to Import Specification, I have set the data type in Design
    > View to text. (Is this what you are referring to?) -- Would the fact this
    > data came from an sql server make any difference? All fields in the

    database
    > are text fields.
    > Thanks for your input and my bad if I sound vague. This really has me
    > stumped.
    >
    >
    > "tina" wrote:
    >
    > > i'm guessing that the first record has a value starting with a number in

    the
    > > alpha/numeric field, and it's being wrongly interpreted as numeric.

    that's a
    > > problem if 1) you're importing to a "new" table, rather than an existing
    > > one, and/or 2) you're not using a saved Import Specification where the
    > > alpha/numeric field has been specified as text.
    > >
    > > did you create an Import Specification that sets the alpha/numeric field

    as
    > > text? and then save it for future use?
    > >
    > >
    > > "Red" <Red@discussions.microsoft.com> wrote in message
    > > news:EBD3A954-D234-432E-A887-6C90AC4E3D0C@microsoft.com...
    > > > tina,
    > > > thanks for reply. I am using text data type (also, Memo) and the

    error
    > > > table is still building. The number fields load ( ie: 132, 054) but

    the
    > > > alpha/numeric do not (ie: b3r, 1am).The data does not appear in the

    table
    > > > after import completes - only a blank cell.
    > > > Thanks again for your help.
    > > > Red
    > > >
    > > >
    > > > "tina" wrote:
    > > >
    > > > > when you import the text file, are you using a saved Import

    > > Specification?
    > > > > if the field in the text file is mixed alpha/numeric, the field in

    your
    > > > > table will have to be Text data type (or Memo). make sure that the

    text
    > > file
    > > > > field is designated as Text in the Import Specification.
    > > > >
    > > > > is the Type Conversion Failure occurring on every record in the

    table?
    > > or
    > > > > just certain records? and does the data exist in the record(s)

    > > generating an
    > > > > error? or does the data fail to save in that field in the record(s)?
    > > > >
    > > > > hth
    > > > >
    > > > >
    > > > > "Red" <Red@discussions.microsoft.com> wrote in message
    > > > > news:C55D9F6E-0E0F-4026-B622-BB4F60F05293@microsoft.com...
    > > > > > I am loading data from a text file into an access table. One field

    is
    > > > > > alpha/numeric and when it loads an error table is created - the

    error
    > > is
    > > > > > 'Type Conversion Failure'.
    > > > > >
    > > > > > I have tryed setting the field to number and text but still

    receive
    > > the
    > > > > > error. Is there a setting that will let whatever is in the field

    > > (number
    > > > > or
    > > > > > letters) load as text?
    > > > > >
    > > > > > Thanks for any help you may provide.
    > > > > > Red
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >
     
  2. Loading...

    Similar Threads Forum Date
    USA Are Turban-Wearing Sikhs TSA Targets? Sikh Coalition Uploads App Breaking News Nov 28, 2013
    Legal Protect Your Places of Worship (Download the US Government Guide) Breaking News Jul 8, 2013
    Download Kahn Singh Nabha's Mahan Kosh - English Translations Literature Jul 8, 2013
    Where to find Waheguru Simran album downloads? Questions and Answers Jul 7, 2012
    Sikh Books downloads Intellectual Translations by SPNers May 27, 2012

Share This Page