in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.
All Tags » Excel (RSS)

Browse by Tags

  • Re: Error while changing tabs in Profiler

    For anybody checking this post, the issue was that the version of Excel selected in the connector did not match the Excel file. Regards Admin
    Posted to Inaport (Forum) by admin on 06-09-2009

  • Data typing in Excel

    A problem sometimes arises when trying to read data from an Excel spreadsheet. There may be data in cells, but when you look at it in the preview pane in Inaport, the cells look empty. Fundamentally, Excel is NOT a database and the columns in a spreadsheet do not have a data type associated with them...
    Posted to Knowledge Base (Forum) by admin on 03-25-2009

  • Updating source database during an import

    Occassionally, it is necessary to update the source or target database during an import operation. For example, it may be necessary to flag a source record as processed. Inaport supports this using the "dbexecupdate()" function, that allows you to perform an arbitrary SQL UPDATE statement against...
    Posted to Knowledge Base (Forum) by admin on 10-31-2008

  • Excel numbers as text

    A common problem when reading data from Excel is that numbers may be formatted as text, but are still really numbers and are treated as numbers when read by Inaport. The most common example is US zip codes. In Excel, they look like "12345" or "00123", but when read by Inaport they...
    Posted to Knowledge Base (Forum) by admin on 05-07-2008

  • Re: String format from Excel

    Hi Doug The first problem is ensuring you have consistent data types in Excel. From your description, it sounds like some cells may have numbers and some have text. The problem with this is that the Excel data driver has to choose a single data type for each column in the worksheet. It does this by examining...
    Posted to Priority Support (Forum) by admin on 04-24-2008

  • Excel ODBC error - "The field is too small ..."

    While importing from an Excel spread sheet you see the following error message "[Microsoft][ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data". This is problem with the Excel ODBC driver which can often be worked...
    Posted to Knowledge Base (Forum) by admin on 03-16-2008
Page 1 of 1 (6 items)
InaPlex Limited 2008