I BCP out a table and then import back. While BCP IN, i get the following error:
#@ Row 303, Column 5: Invalid character value for cast specification @#
#@ Row 296, Column 4: String data, right truncation @#
Help plz!
I am trying to simplify a query given to me by one of my collegues written using the query designer of Access. Looking at the query there seem to be some syntax differences, so to see if this was the case I thought I would import the database to my SQL Server Developer edition.
I tried to start the wizard from within SQL Server Management Studio Express as shown in one of the articles on MSDN which did not work, but the manual method also suggested did work.
Trouble is that it gets most of the way through the import until it spews forth the following error messages:
- Prepare for Execute (Error)
Messages
Error 0xc0202009: {332B4EB1-AF51-4FFF-A3C9-3AEE594FCB11}: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Could not start session. Too many sessions already active.".
(SQL Server Import and Export Wizard)
Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)
Error 0xc004701a: Data Flow Task: component "Source 33 - ATable" (2065) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard).
There does not seem to be any method of specifying a number of sessions, so I don't see how to get round the problem.
Does anyone know how I can get the import to work?
Hi all,
when trying to Ãmport files to our database server from a client, I keep getting an error:
- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
(SQL Server Import and Export Wizard)
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
(SQL Server Import and Export Wizard)
... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.
I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.
best regards
Musa Rusid
When i import the data from Foxpro .dbf file to sql, there is error:
Insert error, Column 47 ('mrlvbd',DBType_DBTimeStamp),status 6: Data Overflow.
Then i found out that it might be because of the date field of the data is blank. What can i do to solve this?
Thanks in advance
Hi, trying to import data from a MySQL DB to MSSQL 2005. Having some errors with collating it looks like. Maybe the syntax is incorrect...not sure. Never imported this way.
here is the import to create a table.
SET AUTOCOMMIT=0;
START TRANSACTION;
CREATE TABLE "tbl3215" (
"id" int(11) NOT NULL,
"IttNumber" text collate latin1_general_ci NOT NULL,
"IttTitle" text collate latin1_general_ci NOT NULL,
"IttDescription" text collate latin1_general_ci NOT NULL,
"IttJustification" text collate latin1_general_ci NOT NULL,
"TechSolution" text collate latin1_general_ci NOT NULL,
"DateReceived" text collate latin1_general_ci NOT NULL,
"DateRequired" text collate latin1_general_ci NOT NULL,
"Customer" text collate latin1_general_ci NOT NULL,
"OrgID" text collate latin1_general_ci NOT NULL,
"Funded" text collate latin1_general_ci NOT NULL,
"HBApID" text collate latin1_general_ci NOT NULL,
"Disapproved" text collate latin1_general_ci NOT NULL,
"DisReason" text collate latin1_general_ci NOT NULL,
"Completed" text collate latin1_general_ci NOT NULL,
"CompletionDate" text collate latin1_general_ci NOT NULL,
"Priority" text collate latin1_general_ci NOT NULL,
PRIMARY KEY ("id")
) AUTO_INCREMENT=4735 ;
here is the error returned.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='.
Msg 448, Level 16, State 2, Line 6
Invalid collation 'latin1_general_ci'.
Msg 448, Level 16, State 2, Line 7
Invalid collation 'latin1_general_ci'.
Msg 448, Level 16, State 2, Line 8
Invalid collation 'latin1_general_ci'.
Msg 448, Level 16, State 2, Line 9
Invalid collation 'latin1_general_ci'.
etc...
Now, i am not sure how to make this work, i am thinking sql2005 may not recognize latin1_general_ci? Is there a quide to which databases use which character sets and their incompatibilities?
Any help appreciated
Joe
I have created a DTS to import some data into a table. It is importing a tab delimited text file and I am getting an error when importing into a decimal field.
I have imported the data into a table with all the fields as varchar. The reason that I am getting this error is that the column that is giving me the errors is trying to populate the cells with a " " when there is no information!
Is there anything that I can do in order to treat that as a null?
I'm using the import wizard to create a new table from. The table gets created but no data gets copied.
In preview all is OK. I have MS Windows Samall Bussines Server 2003R2 Premium Edition with SQL 2005 WorkGroup Edition. In help/manual for this version is SSIS including but SSIS as service dosn't run.
Generate report:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Error)
Messages
* Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - .....1).
(SQL Server Import and Export Wizard)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Success)
- Copying to [BayadaPortal].[dbo].[inSsrc] (Stopped)
- Post-execute (Stopped)
- Cleanup (Stopped)
I receive unhelpful errors from attempting to import a ms access table into sql server 2005 using the import wizard. Here is the report.
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (73).
(SQL Server Import and Export Wizard)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Success)
- Copying to [Company].[dbo].[EMPLOYEE] (Stopped)
- Post-execute (Stopped)
- Cleanup (Stopped)
I received this type of error once before and got around it by removing all constraints from the table. I was able to import the table when the data types were nvarchar. I changed the data types to varchar and this occurred. How do I know what the message is specifically referring to or can I see more details of the import command. This is my first posting.
Im trying to import a tbl from access why am i getting this msg?
Error at destination for row #58
Insert error, colm 6 ('Check Date, dbtype_dbtimestamp), status 6: Data over flow.
Invalid character value for cast specification.
This is my source data in CSV format:
4,23,2AY5623,7235623
4,23,2GP1207,1451207
4,23,2GQ6689,4186689
Table:
CREATE TABLE [dbo].[Table1](
[idCodeLevel] [int] NOT NULL,
[idFirm] [int] NOT NULL,
[valCodeFrom] [varchar](15) NOT NULL,
[valCodeTo] [varchar](15) NOT NULL
) ON [PRIMARY]
[code]....
I googled and found out that I might have to use the format .fmt. But how can I convert a csv file to fmt. I have seen code to create fmt file from sql table.
Hi there
I am importing data from a database on one server to the same database (exactly the same table structure etc) on another server. I am specifying the data from certain tables on the source database which are completely empty on the destination database. The tables on the destination database each have a primary key column (Identity Specification = YES, Is Identity = YES, Identity Increment = 1, Identity Seed = 1, Not for Replication = YES).
The error i'm getting is as follows:
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "GroupID".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination - YvGroup" (40)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)
I'm sure the most important error is the first one, "Data Flow Task: Failure inserting into the read-only column". Is this happening because i'm trying to import data into primary key columns that are usually populated by an auto incremented integer and is seeing it as read only?
How can I get round this?
Cheers
I'd like to set up a dts package to import .csv files and on testing one .csv with only one row I am getting this error:
Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Error Description: Too many columns found in the current row; non-whitespace characters were found after the last defined column's data.
data set from .csv:
-31,0,"CENTER","","","64 ROCK DR. #4100","BETH","MD.","20417","0470-5",30109,10598,"52492000 083","1018","406800","6896CE","7007","G00887",1,13983.24,2139.66,42741.9,150101.36,830317.41,1562843.99,30128.45,2,506,0,0,0,0,0,0,37.87,1,0,0,476.39,472.15,0,1191.12,0,90073.46,43038.97,0,309926.59,-14880.49,20060102,20090101,"A","","",""," ","C62454",0,0,0,0,0,0,0,0,8.39,0,0,0,0,"",0,"00000000",""
Using an access project front-end to an MSDE database, I'm trying toimport a spreadsheet using File->Get External Data->Import.After I select the spreadsheet name, I tell it I want to import into anexisting table and select the table name from the list. The name inthe list is dbo.Cost_Data. When I tell it to finish, it says the tabledoes not exist.If I do the same steps as the database owner, the table name does notcontain the "dbo." on the front of it and it is successful.Thanks for any help.Jerry
View 1 Replies View RelatedHey guys!!!
Please help me with this, when i try to import a database made in access to sql server 2005 i get the following error....
TITLE: SQL Server Import and Export Wizard
----------------------------------------
The SSIS Data Flow Task could not be created. Verify that DTSPipeline.dll is available and registered. The wizard cannot continue and it will terminate.
----------------------------------------
ADDITIONAL INFORMATION:
Value does not fall within the expected range. (Microsoft.SqlServer.DTSRuntimeWrap)
----------------------------------------
BUTTONS:
OK
----------------------------------------
It worked fine, but i had to uninstal SQL and when i installed again i came across this problem....
plz plzzzz... do resolve this issueee .. ive two months for the project and im stuck with this thing for the last 2 weeks at initial stage.
While attempting to import data from Excel using SSMS and the import/export wizard, I received the following error:
TITLE: SQL Server Import and Export Wizard
An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.
ADDITIONAL INFORMATION:
Exception has been thrown by the target of an invocation. (mscorlib)
The connection type "EXCEL" specified for connection manager "{11CD789E-0DCD-48C8-81F9-1065D87B5ADF}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
({BB3EBEA7-7F0E-4346-A8A5-60E176732365})
Any clues as what causes this and how to resolve the problem. I am using Office XP.
Hello,
I am trying out a simple SSIS package to import data from an xls into a table. For this I am using an Excel Source and an OLEDB Destination.
One of the fields is called Notes. In the Excel Source, I have specified the Notes columns as Unicode string [DT_WSTR]. This maps to a SQL Table column which is nvarchar(max)
The error messages that I get are :
[Excel Source [1]] Error: An OLE DB error has occurred. Error code: 0x80040E21.
[Excel Source [1]] Error: There was an error with output column "Notes" (272) on output "Excel Source Output" (9). The column status returned was: "DBSTATUS_UNAVAILABLE".
[Excel Source [1]] Error: The "output column "Notes" (272)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "Notes" (272)" specifies failure on error. An error occurred on the specified object of the specified component.
Could anyone please help me with this.
regards,
Satya
Hi all,
I am trying to import a few tables into a database and when I run the import wizard, it gives an error at the Validating stage. Below are the errors. I don't know why this could be happening.
Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "RowID".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination - gAMD_Color_D_1_0" (343)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)
I get the following error during the execution of my package and can't understand the reason:
The INSERT statement conflicted with the FOREIGN KEY constraint
I use a lookup to import keys to my fact table as I do with the rest of the dimensions. Does anyone faced this error message before?
Thanks
Hi, I am having problems running my import query. It runs to a point, then the next block of SQL it fails on, does anyone know why this is? I have included the code and the error message underneath. The import is ran using SQLwebadminThanks
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [HOME_RECORDS]
AS
SELECT dbo.TEAMS.TEAM_ID, ISNULL(dbo.HW.COUNT_HOME_WINS, 0) AS W, ISNULL(dbo.HD.COUNT_HOME_DRAWS, 0) AS D,
ISNULL(dbo.HL.COUNT_HOME_LOSES, 0) AS L, ISNULL(dbo.HW.HGF, 0) +
ISNULL(dbo.HD.HGF, 0) + ISNULL(dbo.HL.HGF, 0) AS F,
ISNULL(dbo.HW.HGA, 0) + ISNULL(dbo.HD.HGA, 0) + ISNULL(dbo.HL.HGA, 0) AS A
FROM dbo.TEAMS LEFT OUTER JOIN
dbo.HW ON dbo.TEAMS.TEAM_ID = dbo.HW.F_HOME_TEAM LEFT OUTER JOIN
dbo.HD ON dbo.TEAMS.TEAM_ID = dbo.HD.F_HOME_TEAM LEFT OUTER JOIN
dbo.HL ON dbo.TEAMS.TEAM_ID = dbo.HL.F_HOME_TEAM
The following error occured while executing the query:
Server: Msg 208, Level 16, State 1, Line 3
Invalid object name 'dbo.HW'.
hi all,
I'm trying to import export a database into another server
and i get an error:
"The license for the installation of the Microsoft SQL Server on your source and destination coonectins does not permit the use of DTS to transform data.
refer to your license agreement for more information..."
Can anyone tell me a workaround to this problem???
thank you
I am getting an error inserting a simple text file into a SQL2000 database table.
The text file is one column, comma delimited, and the DTS package to insert it into a table fails citing an error executing a 'COLLATE' statement.
Thanks for the help!
I get the following error when i use DTS Table Import task.
Createfile error on 'Servername.DBname.LOG'. Access is denied.
Please help
have tried to import data from a big (257Mb, I has about 1.000.000) flat file into a table, inside SSIS. The process doesn’t work correctly. It stops in the same register (about 179.000). I have reviewed the process and have opened the file making it shorter (about 150.000 lines, including the line that before seems to break the process), and it works. Making the file longer it breaks the process again.
The error showed by the program:
Error: 0xC02020A1 at Data Flow Task, Flat File Source [2820]: Data conversion failed. The data conversion for column "debe" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
Error: 0xC0209029 at Data Flow Task, Flat File Source [2820]: The "output column "debe" (4066)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "debe" (4066)" specifies failure on error. An error occurred on the specified object of the specified component.
Error: 0xC0202092 at Data Flow Task, Flat File Source [2820]: An error occurred while processing file "Z:PROYECTOS ITSoluciones de negocioProyectosSANDOProyecto 5. CodificaciónETLcapun00108.unl" on data row 36804.
Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "Flat File Source" (2820) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.
Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.
Anybody knows what could be happening?
Any help would be very appreciated
Thanks
PD: I mean that it´s not a date format problem (I have reviewed some post talking about it)
I am trying to import data from Excel into SQL using the import Wizard. All seems to go fine until the last couple of steps where I get this error.
error 0xc00470fe - The product level is insuficient for component "source-update$" (1)
Does anyone know what this means?
I am attempting to import an excel sheet to SQL and keep coming up with the following error:
Error during transformation ... row number 29
TransformCopy conversion error: Destination does not allow null
Source column 'ProductID' (DBTYPE_R8),
Destination column 'ProductID' (DBTYPE_STR)
When I look at row 29, the ProductID is '1240000A' and not NULL.
All prior ProductID's had no Alpha characters ans appeared as 7 digits eg. '1240000'. I Previewed the data before the transformation and for some reason the ProductID '1240000A' appears as NULL, even though the Excel Sheet has the value '1240000A' entered. Help would be appreciated. Thanks.
Hello everyone,
I'm having difficulties in Importing data using DTS with a SQL Query.
The Sql query :
SELECT *
FROM Organisations
where Organisations.OrganisationID = 1
I receive this Error Message :
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : Deferred prepare could not be completed.
SELECT permission denied on object 'Organisations', database 'souce_db', owner'dbo'.
Context : Error calling GetColumnInfo. Your Provider does not supprt all the interface/methods required by DTS.
Can anybody help me . Thanks
I am using the import Wizzard in SQL Server 2005 for the first time and trying to import some excel data into the db table.
I keep getting this error. Any ideas??
- Validating (Error)
Messages
Error 0xc02020f6: Data Flow Task: Column "game_ID" cannot convert between unicode and non-unicode string data types.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination - cfb_boxscores" (137)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)
Here is the error:
TITLE: SQL Server Import and Export Wizard
------------------------------
An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.
------------------------------
ADDITIONAL INFORMATION:
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
The connection type "EXCEL" specified for connection manager "{55E5636D-F2A9-48D6-9723-867C9F241F5B}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
({F390DBA3-1B52-43F4-A624-9E71D273B4D7})
I really need to get this data into SQL server... why do I have to go through SQL 2000?
Regards,
HI I'm still in the middle of this 2000 to 2005 64 bit migration!! I have managed to create an oledb connection to my informix db. Within the data flow I wanted to create a simple data pump from my infdormix db to S2K5 db.
Now in the OLEDB source I have done a select froma table to which I can view. I also set the always use default code page to true.
On the error box I get
[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Live@jvert07_se.service" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error 1 Validation error. Reason code: OLE DB Source [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Live@jvert07_se.service" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Cerptransfer.dtsx 0 0
Also when I try to execute it I get
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Reason code [OLE DB Source [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Live@jvert07_se.service" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error at Reason code [DTS.Pipeline]: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
Error at Reason code [DTS.Pipeline]: One or more component failed validation.
Error at Reason code: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
Can anyone help as i'm dead in the water now.
many Thanks
robert
When I try import a SSIS package into the MSDB I get the following error message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
The SQL server specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2005 Books Online.
The .Net Framework OleDb Data Provider requires Microsoft Data Access Components(MDAC) version 2.6 or later. Version 2.12.4202.3 was found currently installed. (MsDtsSrvr)
------------------------------
BUTTONS:
OK
------------------------------
I do have default instance installed and the SSIS servie is running. When I look at the SSIS service configuration it shows a period for the server which I thought meant local host. Also I have MDAC 2.8 installed. What else do I need to look at?
I am attempting to import data from an access db using the wizard and I get the following error when the wizard attempts to save.
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Saving (Error)
Messages
* Error 0xc0208220: Data Flow Task: Unable to save to XML.
(SQL Server Import and Export Wizard)
Does anyone have any ideas about how to correct this?
I have a remote database which I need to make a local copy of. I have sucessfully scripted the db and created it locally. however I cannot import the data to the local server. I get this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot truncate table
i think i am doing everything ok but it still wont work.dbo.xxx beacause its being referenced by a foreign key constraint.
Any ideaas welcome.
Gary
Hi there
I am importing data from a database on one server to the same database (exactly the same table structure etc) on another server. I am specifying the data from certain tables on the source database which are completely empty on the destination database. The tables on the destination database each have a primary key column (Identity Specification = YES, Is Identity = YES, Identity Increment = 1, Identity Seed = 1, Not for Replication = YES). The import fails on the first table (YvGroup) whose primary key, "GroupID", is the foreign key within other tables (Relationship is set).
The error i'm getting is as follows:
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "GroupID". (SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task: Column metadata validation failed. (SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination - YvGroup" (40)" failed validation and returned validation status "VS_ISBROKEN". (SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation. (SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation. (SQL Server Import and Export Wizard)
I'm sure the most important error is the first one, "Data Flow Task: Failure inserting into the read-only column". Is this happening because i'm trying to import data into primary key columns that are usually populated by an auto incremented integer and is seeing it as read only? Or is it due to the relationship with other tables? In which case if you have a table structure set up with relationships how would you ever be able to import data?
How can I get round this?Cheers