Not recognising Select Destination Table while uploading data into MS SQL

database
uiautomation
studio
recording

#1

Hello, I need to import excel data into sql, Due to few data types and format issue we are not able to import using Database activities which are available in Ui path. So iam trying to automate it by using Sql server Import/Export wizard but recorders and Ui path objects are not able to select my destination table, please can any one help me on this.


#2

Hi rakeshadn,

What MS SQL version do you have? And what’s the Studio version?

It works with MS SQL version 17, Studio 18.1.4.


#3

Iam using ms sql 2014, please can you upload ine sample xaml file, because date colums and decimal columns are not able to import using Ui path database activities