![]() ![]() Since doing it in a DTS is too complicated, I'm trying to do it with a little C# program, but I'm having problems when I need to import a CSV files: this file is using semicolons as field delimiters instead of commas and I can't get the. If you try, you receive the following error message: "Could not decrypt file.I need to perform a complex import in a Microsoft SQL Server 2000. If the Excel workbook is protected by a password, you cannot open it for data access, even by supplying the correct password with your connection string. If you try, you receive the following error message: "Could not decrypt file."Ī workaround for the "could not decrypt file" problem Excel 97 Excel 2000 Excel 2002 Excel 2003 Excel 2000Ī workaround for the "could not decrypt file" problem Excel 97 Excel 2000 Excel 2002 Excel 2003 Excel 2002Ī workaround for the "could not decrypt file" problem Excel 97 Excel 2000 Excel 2002 Excel 2003 Excel 2003 ![]() Use IMEX=0 instead to be sure to force the registry TypeGuessRows=0 (scan all rows) to work. Please also note that adding the IMEX=1 option might cause the IMEX feature to set in after just 8 rows. That's the key to not letting Excel use only the first 8 rows to guess the columns data type. "SELECT * FROM ", start picking the data as of row 5 and up to column D.Ĭheck out the located registry REG_DWORD "TypeGuessRows". ![]() excel worksheet name followed by a "$" and wrapped in "" brackets. Note that this option might affect excel sheet write access negative. "IMEX=1 " tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. "HDR=Yes " indicates that the first row contains columnnames, not data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |