Results 1 to 9 of 9

Thread: ODBC Exporting Error

  1. #1
    AUGI Addict hand471037's Avatar
    Join Date
    2003-05
    Location
    Oakland, California
    Posts
    1,934
    Login to Give a bone
    0

    Default

    Hey all,

    I've been doing some work with making complex Excel Spreadsheets to parse the ODBC export out of Revit for cost models. And I've hit a snag. Everything was working great, but now when I try to export to an existing ODBC database via the Excel file driver, I keep getting error message '22' from the driver.

    Any clue what's going on?

    Thanks a ton!

  2. #2
    Revit Guru gregcashen's Avatar
    Join Date
    2003-05
    Location
    Emeryville, CA
    Posts
    1,352
    Login to Give a bone
    0

    Default Re: ODBC Exporting Error

    From the Revit help file:

    Autodesk® Revit® has tested the following ODBC drivers:

    Microsoft Access
    Microsoft Excel
    ODBC Exports to Excel create one table per worksheet.
    You can export to an Excel file only once. Multiple exports to Excel are not supported.
    Microsoft SQL Server
    Microsoft Text Driver: Not supported by Autodesk Revit.
    Autodesk Revit may be able to interface with other ODBC drivers, depending on the features supported by the driver. Contact Autodesk Revit Client Support for assistance.
    ...so I think what you are trying to do (export multiple times to the same excel spreadsheet) won't work...

  3. #3
    AUGI Addict hand471037's Avatar
    Join Date
    2003-05
    Location
    Oakland, California
    Posts
    1,934
    Login to Give a bone
    0

    Default Re: ODBC Exporting Error

    aw ****!

    But I think I can figure out a way to make this work.... grrrr....

    Thanks for the tip Greg!

  4. #4
    AUGI Addict
    Join Date
    2003-11
    Location
    New Zealand
    Posts
    1,116
    Login to Give a bone
    0

    Default Re: ODBC Exporting Error

    Jeffrey,

    Can you post the complete error message? Trying to export twice to a XLS should give you this message:

    [code:1:c746286ef4][HY000] [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM. (-5410)[/code:1:c746286ef4]

    Which is an ODBC error message as per
    http://msdn.microsoft.com/library/de...rror_codes.asp

    Greg's right, using Excel is really only good for a once off export unless you manipulate, extract data from a MDB from within excel (using VB).

    ODBC is not a database, just a way of talking to the database. In this case excel is the database. To take data from any project into your special spreadsheet you need to either export to a temp.xls file and then merge in differences or create an access database (MDB) and extract the data from this.

    For doing what you want to do a simple API that allowed you to PULL data from a project would be the ideal

    Guy

  5. #5
    AUGI Addict hand471037's Avatar
    Join Date
    2003-05
    Location
    Oakland, California
    Posts
    1,934
    Login to Give a bone
    0

    Default Re: ODBC Exporting Error

    is it possible to dump ODBC data from Revit to Access multipule times?

  6. #6
    Revit Guru gregcashen's Avatar
    Join Date
    2003-05
    Location
    Emeryville, CA
    Posts
    1,352
    Login to Give a bone
    0

    Default Re: ODBC Exporting Error

    Quote Originally Posted by Jeffrey McGrew
    is it possible to dump ODBC data from Revit to Access multipule times?
    Yes. It should also be possible to do the excel multiple linking thing using Ken Stowe's script...however that works!?!

  7. #7
    AUGI Addict
    Join Date
    2003-11
    Location
    New Zealand
    Posts
    1,116
    Login to Give a bone
    0

    Default Re: ODBC Exporting Error

    Jefffrey

    is it possible to dump ODBC data from Revit to Access multipule times?
    Yes, and you can dump multiple projects to the same database if you want. There are some issues with doing this and it's not my preferred method. I prefer one database/project.

    Guy

  8. #8
    I could stop if I wanted to Marek Brandstatter's Avatar
    Join Date
    2003-08
    Location
    Johannesburg, South Africa
    Posts
    214
    Login to Give a bone
    0

    Default Re: ODBC Exporting Error

    It should also be possible to do the excel multiple linking thing using Ken Stowe's script...however that works!?!
    Ken Stowe's journal script automates the batch export of multiple schedules from a single project file to multiple deliminated txt files. These txt files can be then be linked to a "master" Excel file, that parses them and repopulates itself. Without the script you would have to individually export each schedule.

    If your skills lie with Excel this is probably the best way to go as you don't need to interact with the entire ODBC database - just the schedule data you require.

    If you're confortable with Access or SQL, AND you've familiarized yourself with Revit's ODBC tables - then ODBC Export to Access as this is a one-step process. With each export, Revit repopulates the ODBC table information to correspond to the project.

  9. #9
    AUGI Addict hand471037's Avatar
    Join Date
    2003-05
    Location
    Oakland, California
    Posts
    1,934
    Login to Give a bone
    0

    Default Re: ODBC Exporting Error

    If you're confortable with Access or SQL, AND you've familiarized yourself with Revit's ODBC tables - then ODBC Export to Access as this is a one-step process. With each export, Revit repopulates the ODBC table information to correspond to the project.
    This is more along the lines of what I working on. I want to make an automatic thing based off of ODBC, vs. the Scripting export. Thanks for all the help!

Similar Threads

  1. Exporting schedules to Microsoft Access - ODBC database
    By kristinewander in forum Revit - Plotting/Printing/Exporting
    Replies: 7
    Last Post: 2012-01-05, 10:39 PM
  2. Exporting to ODBC changes values
    By kplusa in forum Revit - Platform
    Replies: 1
    Last Post: 2010-04-26, 10:05 PM
  3. Exporting Linked REVIT Models to ODBC
    By sdoran in forum Revit - Platform
    Replies: 1
    Last Post: 2008-12-16, 03:18 PM
  4. ODBC Export Error
    By Chirag Mistry in forum Revit Architecture - General
    Replies: 4
    Last Post: 2007-10-18, 10:20 PM
  5. Shared Parameters Not Exporting to ODBC
    By Duffy in forum Revit Architecture - General
    Replies: 10
    Last Post: 2007-09-25, 10:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •