Import tables from Excel or Access and data truncates

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: AJ (AJ_at_discussions.microsoft.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 08:29:04 -0700

I have a table that I need to import into my SQL database. I have it in
Excel as well as Access. A couple of the columns are long strings of text
(5000-7000) characters. I see the data correctly in Excel or Access. The
SQL table that I'm trying to import into is defined as:

CREATE TABLE [dbo].[X_SS_Notes] (
[ID] [float] NULL ,
[Note1] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Note2] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Note3] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Importing the table (via DTS) from either Excel or Access seems to go fine
(no error messages). However, when I look at the fields in SQL, the data
truncates around 255 characters.

Am I overlooking something simple?

Relevant Pages

  • Re: SQL query to Excel file
    ... I think Excel is awesome. ... I HAVE to work with a SQL database ... Preferable Access Data Projects if you're using SQL Server. ... Dim objexcel As Excel.Application ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)
  • RE: Macro
    ... Then post the query results. ... My data is in an Excel file called ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ... VBA code in excel suddenly became un-compileable. ...
    (microsoft.public.excel.programming)
  • Re: Question for Joe Fallon--determining Data type
    ... then the data type for the column will be Text. ... means 255 characters max (that's a Jet limit). ... where MSDE or SQL Server is the main database (in these cases Jet ... Is 'Spreadsheet' an MS euphemism for 'Excel' or does it support other ...
    (microsoft.public.access.externaldata)
  • Re: Excel Sheets Opens Itself Again After ADO Query ! Please Help
    ... I'm using Excel 2003 so hopefully its similar to your setup. ... You should then be asked for the workbook to query ... You should see a SQL button now where you can edit the ... Hope this opens the discussion more. ...
    (microsoft.public.excel.programming)