Welcome to SPN

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

Sign Up Now!

Determining data type of imported data

Discussion in 'Information Technology' started by JoeA2006, Jul 28, 2006.

  1. JoeA2006

    JoeA2006
    Expand Collapse
    Guest

    I am working with an Access application that requires importing Excel Data
    into an exisiting table. The new data overwrites the old data each time, but
    for the application to work it has to use that existing table with columns
    with data types, Text, Date, Number. Sometimes the data from excel imports as
    Number in the first column even if it is formatted as general or text. Is
    there a work around for this, or is there a way for the app to compare the
    two datatypes and switch the type if it is incorrect.
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 19 Jun 2006 13:23:01 -0700, JoeA2006
    <JoeA2006@discussions.microsoft.com> wrote:

    >I am working with an Access application that requires importing Excel Data
    >into an exisiting table. The new data overwrites the old data each time, but
    >for the application to work it has to use that existing table with columns
    >with data types, Text, Date, Number. Sometimes the data from excel imports as
    >Number in the first column even if it is formatted as general or text. Is
    >there a work around for this, or is there a way for the app to compare the
    >two datatypes and switch the type if it is incorrect.


    Two suggestions:

    - Don't directly Import the spreadsheet; instead, link to it, and run
    an Append query loading your (correctly datatyped) Access table.

    - If necessary, put a dummy row at the top of the spreadsheet with an
    unambiguous text field ('X for example) above each such column.

    John W. Vinson[MVP]
     

Share This Page