Search results
26 lip 2019 · External table is not in the expected format. This happens when the Excel file is corrupted and cannot be opened by Access Database Engine (OLE DB provider) even if you can open the file from Excel. In a similar case opening the file manually and saving it as a new file may do the trick.
30 lip 2014 · I have several identical files with similar schemas, and all of them work correctly. However this one file throws the "External table is not in the expected format" error. This is what I have tried: I already changed the connection string from Jet OLEDB to ACE OLEDB, no result.
29 lis 2019 · I'm trying to open all appropriate PDFs found in the same directory as my Excel workbook using VBA. I've added the Adobe Acrobat xx.x Type Library reference to the project. But when I try to create the .App object I get a "Run-time error '429':" error.
10 cze 2019 · I embed the PDF by using the basic Insert Object. But nothing is happening, I was able to open them as I started my project but now - I can't open any of the files. I don't even get an error message.
21 cze 2021 · The first error message seems to indicate the SQL Server cannot access the source .xlsx file. Perhaps the account being used by SQL Server does not have access to the file because of filesystem rights, or perhaps the .xlsx is already opened exclusively by some other app, such as Excel.
16 kwi 2018 · The first step is converting the PDF into a format that is more easily processed with SQL and PL/SQL. To that end, Oracle Text includes functionality to parse a PDF BLOB into an XHTML CLOB. With a BLOB containing a PDF with contents that look like this:
If you do want to open a CSV in Excel but with all the data displayed in one column separated by commas, instead of opening it, create a blank sheet in Excel and go to Data » Get External Data > From Text, then choose "fixed width" rather than "delimited".
