Skip to main content
Known Participant
Mar 18, 2024 1:00 PM UTC
Question

import excel data into different database tables

Hi Everyone,

Is there any option to import excel data into Difference Database tables, Pls let me know if any.

Thanks,

Nagesh.

2 replies

stefanhelzle0001
Brainy
Mar 18, 2024 1:41 PM UTC

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.

karumurua531442
Participating Frequently
Mar 19, 2024 4:33 AM UTC

Hi [mention:52de0ce478ae4a25be2fbff46609a4fb:e9ed411860ed4f2ba0265705b8793d05] you can initially dump all the data into temporary table as [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]  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.