Whenever I use the import wizard, importing a csv file takes forever and does not import. How do I solve this?

Cameron Palmer 21

I am trying to import a csv file into azure data studio using the flat file extension, and it will only show the loading icon for the import loading.

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-12-17T13:34:28.87+00:00

Hi, @Cameron Palmer Welcome to the Microsoft Q&A forum, Thanks for posting your question.
Can you please check if there are log files in this folder? Please confirm if you have followed the steps from here also share any error screenshots for a better understanding of the issue.
Error log: /User/AppData/Roaming/azuredatastudio/logs/[dateTtimestamp]/exthost1/Microsoft.mssql/SqlAssessmentLogs

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-12-20T15:39:15.357+00:00

Hi, @Cameron Palmer We haven't heard back from you. Just wanted to check if you had the chance to check my response

Regards
Geetha
Petra Carrion 0 Reputation points

2023-08-02T12:08:31.96+00:00

Hello, I am facing issues with uploading csv files from my local computer via Azure Data Studio . I have many columns and Azure Data Studio maps them incorectly that the file is in the end not imported. I cannot check all the columns because the tables have too many. How can i properly set up the types of the columns?

Regards

Petra

Your answer