Importing rpt file to Access

Discussion in 'Access SQL Server' started by Suttd via AccessMonster.com, May 14, 2007.

  1. Hi,

    I am using SQL advantage 12.5 and have run a query to to bring back results
    in grid with extended character length. but when i copy into txt i loose all
    formating and end up with names in the ID columns does anyone know how to
    export to txt and keep formating or to import to access from an "Rpt" file?

    Thanks in advance

    Dave

    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200705/1
     
    Suttd via AccessMonster.com, May 14, 2007
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. sylmart7

    Automate importing data into SQL Server using .ADP

    sylmart7, Aug 5, 2003, in forum: Access SQL Server
    Replies:
    0
    Views:
    169
    sylmart7
    Aug 5, 2003
  2. Vincent Jones

    importing data..

    Vincent Jones, Oct 11, 2003, in forum: Access SQL Server
    Replies:
    0
    Views:
    83
    Vincent Jones
    Oct 11, 2003
  3. T.J. Bernard

    Locking file after one user is in .ADE file

    T.J. Bernard, Oct 18, 2004, in forum: Access SQL Server
    Replies:
    1
    Views:
    113
    Sylvain Lafontaine
    Oct 18, 2004
  4. Nayana

    Problem:importing macros

    Nayana, Jan 3, 2005, in forum: Access SQL Server
    Replies:
    1
    Views:
    68
    Steve Schapel
    Jan 3, 2005
  5. Chris
    Replies:
    0
    Views:
    76
    Chris
    Feb 14, 2006
  6. Declan

    Importing Access tables into SQL Server

    Declan, Apr 2, 2007, in forum: Access SQL Server
    Replies:
    1
    Views:
    78
    Sylvain Lafontaine
    Apr 3, 2007
  7. Shane Jones

    Importing Data from ACCESS into SQL Server 2005

    Shane Jones, Sep 28, 2007, in forum: Access SQL Server
    Replies:
    4
    Views:
    97
    CHLOE SMITH
    Oct 2, 2007
  8. Laura

    Importing a csv File

    Laura, Apr 24, 2008, in forum: Access SQL Server
    Replies:
    5
    Views:
    95
    Laura
    May 1, 2008
Loading...