Transferring data from database to database
-
This is not exactly a C# question, but I'm not sure where else to ask it. I have an Access database program I wrote some years earlier. I am porting it into C# and trying to import the data from the older database to a newer version of the same database. Some tables are not identical, so I am writing an import feature. The problem I am having is when importing from a memo or text field where the data includes " or ' characters since these characters are needed outside the SQL statement to indicate a text import. Example: "INSERT INTO [Table] ([Field1]) VALUES ('This is a 'very' large project.') Thanks in advance for any help. S Hurt
-
This is not exactly a C# question, but I'm not sure where else to ask it. I have an Access database program I wrote some years earlier. I am porting it into C# and trying to import the data from the older database to a newer version of the same database. Some tables are not identical, so I am writing an import feature. The problem I am having is when importing from a memo or text field where the data includes " or ' characters since these characters are needed outside the SQL statement to indicate a text import. Example: "INSERT INTO [Table] ([Field1]) VALUES ('This is a 'very' large project.') Thanks in advance for any help. S Hurt
Stephen Hurt wrote:
but I'm not sure where else to ask it.
Stephen Hurt wrote:
"INSERT INTO [Table] ([Field1]) VALUES ('This is a 'very' large project.')
Well since that is a SQL statement I would think the SQL / ADO / ADO.NET forum might be helpful? ;)
"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forumled mike
-
This is not exactly a C# question, but I'm not sure where else to ask it. I have an Access database program I wrote some years earlier. I am porting it into C# and trying to import the data from the older database to a newer version of the same database. Some tables are not identical, so I am writing an import feature. The problem I am having is when importing from a memo or text field where the data includes " or ' characters since these characters are needed outside the SQL statement to indicate a text import. Example: "INSERT INTO [Table] ([Field1]) VALUES ('This is a 'very' large project.') Thanks in advance for any help. S Hurt
I think you just double up the single quotes: Example: "INSERT INTO [Table] ([Field1]) VALUES ('This is a ''very'' large project.')