Hi Everyone,
Is there any option to import excel data into Difference Database tables, Pls let me know if any.
Thanks,
Nagesh.
Discussion posts and replies are publicly visible
Not directly. My best practice to import Excel, is to first do a raw import into a temporary table, ignoring all the column names and data types. Then run a stored procedure that does the data typing, and copies the data to its final place.