Import a csv but disabled

[expired user #9805]'s profile image [expired user #9805] posted 8 years ago in Import/Export Permalink

Hi.

I'm trying to import a csv file but these 2 boxes are disabled, why is that?

Insert ignore - disabled Replace - disabled

I'm using 9.3.0.5075

ansgar's profile image ansgar posted 8 years ago Permalink

Are you on MSSQL or PostgreSQL? They both do not support these INSERT IGNORE INTO and REPLACE INTO syntax as far as I know. That's why these options are disabled.

[expired user #9805]'s profile image [expired user #9805] posted 8 years ago Permalink

Yes its MSSQL.

Is there any other way to import and replace ?

Thanks

ansgar's profile image ansgar posted 8 years ago Permalink

Not that I knew of.

Please login to leave a reply, or register at first.