Sample Header Ad - 728x90

Migrate thousand of data from excel into DB

0 votes
0 answers
29 views
I have rental data from year 2019-2024 in an excel In that excel, the data consists of tenant name, monthly payment details from jan - dec each year I have done massaging the data I need to mapping the payment details and tenant details because both details are in different table Can you suggest what tools can I use so I can mapping the payment details with their tenants details Currently, tenant can pay multiple month in one receipt number, so I need cater for that duplicated receipt number also for my migration
Asked by Amirul Safwan (1 rep)
Dec 5, 2024, 02:59 AM
Last activity: Dec 5, 2024, 03:00 AM