search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 899 forks source link

Azure studio import wizard is choosing row as headers #23856

Open Priyanka-droid opened 1 year ago

Priyanka-droid commented 1 year ago

Steps to Reproduce:

I am trying to import a csv data to azure-sql using import wizard. Let's say for example csv data is like this "id";"data_name";"data_val" "demo_id";"name1";"data_val1" "2";"name2";"data_val2" "3";"name3";"data_val3"

then when I import to azure, it choses first row as header demo_id. name1 data_val1 2 name2 data_val2 3 name3 data_val3

but I want to keep the actual headers as header, how can I prevent this from happening

Does this issue occur when all extensions are disabled?: Yes/No

mrlife commented 10 months ago

This happens on some tab-delimited txt files but not others. When it does happen, it is also removing the last column (header and data).