[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
Would something like this work as a query?
rektbyfaith
07-24-2025, 01:01 PM #11Archived author: Mebirdie • Posted: 2025-07-24T13:01:52.375000+00:00
Original source
Would something like this work as a query?
Original source
Same for races 3-11
rektbyfaith
07-24-2025, 01:52 PM #12Archived author: Mebirdie • Posted: 2025-07-24T13:52:21.997000+00:00
Original source
Same for races 3-11
Original source
A bit hacky, but if you got Access it should be possible to import those data from CSV/Excel and export them as SQL insrt queries. Migrated a 400MB DB like that once
rektbyfaith
07-24-2025, 02:00 PM #13Archived author: WolfM90 • Posted: 2025-07-24T14:00:24.754000+00:00
Original source
A bit hacky, but if you got Access it should be possible to import those data from CSV/Excel and export them as SQL insrt queries. Migrated a 400MB DB like that once
Original source
At this point, I just made them into queries and saved them as .sql to be loaded, but for some reason, I am still eating these errors on the WS load
rektbyfaith
07-24-2025, 02:01 PM #14Archived author: Mebirdie • Posted: 2025-07-24T14:01:11.644000+00:00
Original source
At this point, I just made them into queries and saved them as .sql to be loaded, but for some reason, I am still eating these errors on the WS load
Original source
are u showing us full query ? u made stats for class 3 and core is telling u that there are no stats for 4 which is correct since that query is only for class 3
rektbyfaith
07-24-2025, 02:01 PM #15Archived author: Rymercyble • Posted: 2025-07-24T14:01:27.080000+00:00
Original source
are u showing us full query ? u made stats for class 3 and core is telling u that there are no stats for 4 which is correct since that query is only for class 3
Original source
Its a very large list. I just copied a small bit of it for reference
rektbyfaith
07-24-2025, 02:01 PM #16Archived author: Mebirdie • Posted: 2025-07-24T14:01:57.113000+00:00
Original source
Its a very large list. I just copied a small bit of it for reference
Original source
I'll send the full boy in a sec
rektbyfaith
07-24-2025, 02:02 PM #17Archived author: Mebirdie • Posted: 2025-07-24T14:02:32.092000+00:00
Original source
I'll send the full boy in a sec
1 Guest(s)
1 Guest(s)