Unable to Import Excel files into SQL Server
Hello SQL Team,
I’m new to SQL Server & I just created a database and need to import an Excel file.
The problem is that the 3 methods of importing the file has failed.
If I use tasks>import file, the Wizard opens and after indicating the datasource, I get the following error message:
2. If I go to Start and use the SQL Server 2022 Import and Export Data (64-bit) in my pc Apps, I get this error:
3. If I try importing in the csv format and import as a flat file, I get the following error message:
can anyone help please?
Hello SQL Team, I’m new to SQL Server & I just created a database and need to import an Excel file. The problem is that the 3 methods of importing the file has failed. If I use tasks>import file, the Wizard opens and after indicating the datasource, I get the following error message: 2. If I go to Start and use the SQL Server 2022 Import and Export Data (64-bit) in my pc Apps, I get this error: 3. If I try importing in the csv format and import as a flat file, I get the following error message: can anyone help please? Read More