#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Oct 2008
    Posts
    2
    Rep Power
    0

    Smile TASBooks 3 Data Import MS Access


    I am trying to import data from a TAS Books database (Btrieve) using the TASlink Developer Application.

    I can make the connection to the TASBooks database using Excel to drop data into a spreadsheet and have made the same connection in MS Access.

    However I am unsure of how to drop the transaction data into a table in MS Access.

    Any able to help ?

    Thx
  2. #2
  3. No Profile Picture
    Contributing User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2007
    Posts
    83
    Rep Power
    47
    I know nothing about Tasbooks, but im presuming its ODBC compatible, therefore create the appripriate ODBC connections to the respective databases and pass the data back and fourth.
  4. #3
  5. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Oct 2008
    Posts
    2
    Rep Power
    0
    Unfortunately there is no ODBC to this database, we have to use a direct connection string before executing.

Similar Threads

  1. Import Excel Spreadsheet- Data Type Issue
    By ker1978 in forum Microsoft Access Help
    Replies: 1
    Last Post: February 20th, 2007, 05:11 AM
  2. Using VBA to change the Name of a Field in a Union Query
    By pebbleslr in forum Microsoft Access Help
    Replies: 1
    Last Post: February 16th, 2007, 11:09 PM
  3. Importing data from Access to MS SQL
    By gymanual in forum Microsoft SQL Server
    Replies: 4
    Last Post: June 11th, 2005, 12:47 AM
  4. Problem Saving Data in Access
    By arthurbas in forum ASP Development
    Replies: 2
    Last Post: August 2nd, 2004, 03:16 PM
  5. Import data to Access using ASP
    By Steve Schofield in forum SQL Development
    Replies: 1
    Last Post: February 27th, 2001, 08:29 AM

IMN logo majestic logo threadwatch logo seochat tools logo