Re: Import Problems

Tech-Archive recommends: Speed Up your PC by fixing your registry

It would help if you say exactly what the error message is, and the code
that you're using to trigger the import.


"Frank" <fhsmith7@xxxxxxxxxxxxx> wrote in message
news:7AwBf.10181$Io1.8567@xxxxxxxxxxxxxxxxxxxxxxxxx
> I have a sql table in which I import records. I get an error messages
that
> stops the import after 8,000 records are imported .- something about jet
> engine. I restart and import again with the same error message and same
> number of records imported. Usually, I have to import over 20,000 records
> during an import session.
>
> I use Access 2002 front end- SQL Server 2000 backend with Windows XP as
> operating system.
>
> How do I fix this problem? Any assistance is greatly appreciated.
>
>
>


.

Relevant Pages

  • cannot convert between unicode and non-unicode string data types
    ... Cindy, I have the same problem, there is a solution, In the OLE DB Destination component, in the Mappings option in the input column you must choose the Data Conversion., and that's it. ... I am converting a simple (at least in the SQL Server 2000 DTS days) to this ... error message stays the same ... numerous times I have inserted the transformation task between the oracle ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Timeout Error
    ... "Robert Lakinski" wrote: ... but you can access data in Sql server via MS ... I don't know why I got the error message. ...
    (microsoft.public.sqlserver.server)
  • Re: Dup entries when creating a new DB entry (ASP Classic with an MDB file)
    ... machine and it definitely generated an error message when I left the ... initialize the strErrorMsg variable: ... I couldn't get the Parameterized querys to work to replace the SQL ... Dim strTitle ...
    (microsoft.public.inetserver.asp.db)
  • Re: Multilingual versions of SQL Express 2005 available ? Where ?
    ... The error code alone is not sufficient. ... error code which is represented in the parameters used to format the SQL ... language is used. ... > we may consider provide localized error message according to the error ...
    (microsoft.public.sqlserver.setup)
  • Re: cannot convert between unicode and non-unicode data types
    ... product can't actually produce a meaningful error message. ... oracle and the sql database. ... Tried dumping to a raw file but the output is still unicode when I try to ...
    (microsoft.public.sqlserver.dts)