Import Xcel file

• Bruin

  SSCrazy

  Points: 2107

  More actions

  July 14, 2023 at 2:45 pm

  #4235127

  $File = "C:\CostLoads\Book1.xlsx"
  $Instance = "xxxxx"
  $Database = "DBA_USAGE"
  
  $fileName =  [System.IO.Path]::GetFileNameWithoutExtension($File)
  
  foreach($sheet in Get-ExcelSheetInfo $File)
  {
  
  $data = Import-Excel -Path $File -WorksheetName $sheet.name | ConvertTo-DbaDataTable
  $tablename = $fileName + '-' + $sheet.Name
  
  Write-DbaDataTable -SqlInstance $Instance -Database $Database -InputObject $data -AutoCreateTable -Table $tablename 
  
  }

  I'm trying to import my xcel file into SQL but receive this message.

  --The certificate chain was issued by an authority that is not trusted--

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  July 15, 2023 at 3:10 pm

  #4235919

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.