Re: SQLTables

From: Dmitri Ivanov (divanov_NOSP_at_M_.aha.ru)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 15:12:46 +0400

Hello SqlJunkies,
"SqlJunkies User" <User@-NOSPAM-SqlJunkies.com> wrote:

SU> Hi,
SU> The SQLTables API is not working for user genearted excel files. It
SU> works if the excel file is generated by DTS but its not working if
SU> i generate a file manually with the same data
SU>
SU> Here is my code:
SU> AFX_SQL_ASYNC( this, ( ::SQLTables ) ( m_hstmt,
SU> ustrQualifier, SQL_NTS,
SU> ustrOwner, SQL_NTS,
SU> ustrName, SQL_NTS,
SU> ustrType, SQL_NTS ) );
SU>
SU> The parameters are not getting populted for the file which i
SU> created.

Please retrive a related post few weeks ago. (Or better learn Google :-)). 

--
Sincerely,
Dmitri Ivanov
Common Lisp ODBC interface - www.ystok.ru

Relevant Pages

  • Re: Problems with importing Excel files into SQL Server
    ... Settting the IMEX=1 in the DTS Designer package only seemed to work ... > www.SQLDTS.com - The site for all your DTS needs. ... >> I have had problems for years now importing excel files into SQL Server ... and most of the Excel files that I ...
    (microsoft.public.sqlserver.dts)
  • Custom transformation - Table --> Excel file (How to)
    ... What I want to do is to export different tables into different excel files. ... I tried writing custom ActiveX Script task. ... and better do it with ADO outside DTS). ... If I use ActiveX Script with MS OLEDB connection and Excel connection the ...
    (microsoft.public.sqlserver.dts)
  • looping, importing the dirctory of excel files
    ... I can even import directory of text files with DTS ... But when i I try to import the directory of excel files to sql server. ... punctuation and that it is not too long." ... Prev by Date: ...
    (microsoft.public.sqlserver.dts)
  • Dynamic transformations
    ... Can anybody help me with dynamic transformation mapping? ... various Excel files I need to import into SQL tables. ... I created a DTS ... that checks a specified directory and load Excels into db. ...
    (microsoft.public.sqlserver.dts)
  • Re: How To Read the Contents of a Directory
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >I would like to write a DTS package to import a number of Excel files ... Is there a function to read a predefined network directory to obtain ...
    (microsoft.public.sqlserver.dts)