跳到主内容

搜索

搜索

Connecting To Excel

评论

5 条评论

  • Avatar
    Legacy Poster
    [quote name='jeff@ccfe' timestamp='1310386886' post='193']
    Hi,
    New to Bartender. I am trying to connect to an excel spread sheet as a database field and keep getting the unknown error message #6670. Failed to connect to database unknown error 0x800A0BB9. Any ideas???????
    [/quote]

    Is your spread sheet open in Excel when trying to connect to it? If so, try closing it, I know that you can't have it open when connecting to it in BarTender.
    0
  • Avatar
    Legacy Poster
    [quote name='JMI' timestamp='1310399692' post='194']
    Is your spread sheet open in Excel when trying to connect to it? If so, try closing it, I know that you can't have it open when connecting to it in BarTender.
    [/quote]
    0
  • Avatar
    Legacy Poster
    H, Yes the spread sheet is closed, I have tried both open and closed still the same result
    0
  • Avatar
    Shotaro Ito
    Dear jeff@ccfe,
    First, Check your PC's excel connection works in general or not.

    try to create a very simple Excel sheet File such as
    [code]Field1 Field2
    100 John
    101 Becky[/code]

    on Sheet1, then and save as .XLS(Excel 2003) file.

    Create a very simple bartender format, then try to connect the excel database above.
    (for procedure please check [url="http://www.seagullscientific.com/aspx/training-video-(reading-data-from-database).aspx "]the short video[/url])

    If you don't have any error on above, it's likely the Excel sheet you trying to connect has some problem.
    Open the Excel sheet and try to make simplify the sheet.
    (such as select whole sheet, copy, paste to notepad, then copy from the notepad to a new excel sheet)

    If you still have the same error (#6670 etc),
    - Switch Excel format to Excel 2007 format (xlsx) or to Excel 2003 format(xls). In BarTender format, remove database connection setup and connect again.
    - Try ODBC connection to the Excel sheet(You need to create ODBC datasource by ODBC Administrator)

    also in this stage, please ask Seagull Tech Support by e-mail with detailed info, such as BarTender serial number(support number) in Help>About, OS Version/Service pack, Excel version, BarTender format(btw) and the affected Excel sheet attached if possible.
    http://www.seagullscientific.com/aspx/technical-support.aspx

    Hope that helps!
    0
  • Avatar
    Legacy Poster
    [quote name='Shotaro I -Seagull Support' timestamp='1310432748' post='200']If you don't have any error on above, it's likely the Excel sheet you trying to connect has some problem.
    Open the Excel sheet and try to make simplify the sheet.
    (such as select whole sheet, copy, paste to notepad, then copy from the notepad to a new excel sheet)[/quote]

    I've seen this happen. Pasting to a new excel sheet can often clear the problem.

    You may also try saving from Excel to a .txt Tab Delimited file - then try connecting that to Bartender using the Text File option.
    0

请先登录再写评论。