Share via

I was trying to import bulk excel file using the PowerShell coding

Anonymous
2023-01-23T06:48:55+00:00

I was trying to import bulk excel file using the PowerShell scripts coding, my destination is SQL Server, In my spreadsheets there are different data and each columns have has datatypes, how can I declare the data type in PowerShell script, based on the column from the excel sheet including null cells.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-24T07:44:34+00:00

    From your screenshot, I can't know which step is not working on your side.

    You can convert xlsx into csv in excel application and then direct input the csv to SQL.

    0 comments
  2. Anonymous
    2023-01-31T11:55:16+00:00

    Hi Snow,

    While running the code data must be insterted to sql server.. my case unable to populate the data in sql server..

    so that i share the screen shot after ran the code.

    0 comments
  3. Anonymous
    2023-01-31T12:09:38+00:00
    0 comments