You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I find it troubling the Import wizard does not allow you to specify and existing table for importing data into. I realize you would need to allow the user (based on permissions) to either add rows (insert) or modify (update) rows, or truncate the existing table and replace the data with the import data; but the fact you cannot do this is extremely frustrating.
Most other IDEs allow the above features. May I suggest the Import wizard needs to be updated to allow this kind of flexibility?
At this point, if I don't want to leave the UI, I have to write SQL to create a VIEW that does a SELECT * FROM OPENROWSET(BULK, 'filepath', 'formatfilepath') then do an INSERT INTO table from the openrowset VIEW to get the data into the DB. Otherwise, I just end up using another tool in another IDE to get this type of work done.
When can we expect the wizard to start allowing this kind of functionality?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I find it troubling the Import wizard does not allow you to specify and existing table for importing data into. I realize you would need to allow the user (based on permissions) to either add rows (insert) or modify (update) rows, or truncate the existing table and replace the data with the import data; but the fact you cannot do this is extremely frustrating.
Most other IDEs allow the above features. May I suggest the Import wizard needs to be updated to allow this kind of flexibility?
At this point, if I don't want to leave the UI, I have to write SQL to create a VIEW that does a SELECT * FROM OPENROWSET(BULK, 'filepath', 'formatfilepath') then do an INSERT INTO table from the openrowset VIEW to get the data into the DB. Otherwise, I just end up using another tool in another IDE to get this type of work done.
When can we expect the wizard to start allowing this kind of functionality?
Beta Was this translation helpful? Give feedback.
All reactions