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.
Hi Unnam Nageswara Rao you can initially dump all the data into temporary table as Stefan Helzle said, Then build couple of stored procedures using insert and update statements, run these procedures once the data is imported in to temp table. post running the stored procedures and populating the data into different tables, Delete the temporary table using another stored procedure and again import data into temp for next set of back.