[DiscordArchive] Is there any method to quickly transfer data from an excel sheet to the database without inserting e
[DiscordArchive] Is there any method to quickly transfer data from an excel sheet to the database without inserting e
Original source
Is there any method to quickly transfer data from an excel sheet to the database without inserting each entry one by one?
![[Image: image.png?ex=690bed40&is=690a9bc0&hm=9a7...0923ac9c6&]](https://cdn.discordapp.com/attachments/1255602330431127753/1397920052694614117/image.png?ex=690bed40&is=690a9bc0&hm=9a7008e5ba2b6e6ccd1ccd88620495d0e545d90d7ee4a5ef0f77a910923ac9c6&)
rektbyfaith
07-24-2025, 12:35 PM #1Archived author: Mebirdie • Posted: 2025-07-24T12:35:12.726000+00:00
Original source
Is there any method to quickly transfer data from an excel sheet to the database without inserting each entry one by one?
Original source
With AI tools you probably could tell them "convert this csv file into a SQL query"
rektbyfaith
07-24-2025, 12:40 PM #2Archived author: Ryan Turner • Posted: 2025-07-24T12:40:00.780000+00:00
Original source
With AI tools you probably could tell them "convert this csv file into a SQL query"
Original source
Yeah, I guess that would be easy enough. I was hoping for a more /insert type of move but if it isn't possible, I'll just try that instead.
rektbyfaith
07-24-2025, 12:40 PM #3Archived author: Mebirdie • Posted: 2025-07-24T12:40:54.211000+00:00
Original source
Yeah, I guess that would be easy enough. I was hoping for a more /insert type of move but if it isn't possible, I'll just try that instead.
Original source
you could build the query in excel
rektbyfaith
07-24-2025, 12:41 PM #4Archived author: Tereneckla • Posted: 2025-07-24T12:41:12.512000+00:00
Original source
you could build the query in excel
Original source
You could alawys TEXT together in excel
rektbyfaith
07-24-2025, 12:41 PM #5Archived author: Ryan Turner • Posted: 2025-07-24T12:41:22.618000+00:00
Original source
You could alawys TEXT together in excel
Original source
use TEXTJOIN is what i've done in te past
rektbyfaith
07-24-2025, 12:43 PM #6Archived author: Ryan Turner • Posted: 2025-07-24T12:43:37.098000+00:00
Original source
use TEXTJOIN is what i've done in te past
Original source
why use even AI u have excel just create formula to write that query from ur cells and copy that
rektbyfaith
07-24-2025, 12:46 PM #7Archived author: Rymercyble • Posted: 2025-07-24T12:46:33.764000+00:00
Original source
why use even AI u have excel just create formula to write that query from ur cells and copy that
Original source
Because on my laptop i use the copilot because excel runs like shit xD
rektbyfaith
07-24-2025, 12:47 PM #8Archived author: Ryan Turner • Posted: 2025-07-24T12:47:21.456000+00:00
Original source
Because on my laptop i use the copilot because excel runs like shit xD
Original source
Would turning it into a .CSV and importing it work, do you think?
rektbyfaith
07-24-2025, 12:53 PM #9Archived author: Mebirdie • Posted: 2025-07-24T12:53:17.273000+00:00
Original source
Would turning it into a .CSV and importing it work, do you think?
Original source
i can imagine some sql client to support csv but its not feature of sql
rektbyfaith
07-24-2025, 12:53 PM #10Archived author: Rymercyble • Posted: 2025-07-24T12:53:50.593000+00:00
Original source
i can imagine some sql client to support csv but its not feature of sql
1 Guest(s)
1 Guest(s)