Extract excel from SQLDB
-
I need to create a routine that reads all the excel files saved from sql DB. If I have 40 excel files in my DB. I need to extract all one at a time then read the content of the excel file, save it to a grid for reporting. Excel is in standard template with only 4 columns. Hope you could enlighten this. Regards Dabuskol
Dabsukol
-
I need to create a routine that reads all the excel files saved from sql DB. If I have 40 excel files in my DB. I need to extract all one at a time then read the content of the excel file, save it to a grid for reporting. Excel is in standard template with only 4 columns. Hope you could enlighten this. Regards Dabuskol
Dabsukol
dabuskol wrote:
Hope you could enlighten this.
Open the Excel-file (using ADO.NET, or any other library), read the content in a loop, write it to a database. Grids aren't a storage-point, they're used for displaying. What exactly do you need enlightenment with? How to read Excel, how to save it, or the complete task?
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
dabuskol wrote:
Hope you could enlighten this.
Open the Excel-file (using ADO.NET, or any other library), read the content in a loop, write it to a database. Grids aren't a storage-point, they're used for displaying. What exactly do you need enlightenment with? How to read Excel, how to save it, or the complete task?
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
excel files are saved in a database for every record created. What I need is to read this files of every record let say 10 records per run then automatically read the content of each file to a grid for display purposes. In the end all the contect of 10 excel files is displayed in the grid for viewing. no human intervention, automatic with a single button. Regards
Dabsukol
-
excel files are saved in a database for every record created. What I need is to read this files of every record let say 10 records per run then automatically read the content of each file to a grid for display purposes. In the end all the contect of 10 excel files is displayed in the grid for viewing. no human intervention, automatic with a single button. Regards
Dabsukol
dabuskol wrote:
What I need
Who is saving the Excel files, what database? Sql Server? Oracle? Sqlite? Are they saved as a BLOB, or is it a real import? Do you want to "show" 10 excel-files (and their content) in a single grid? How? You'll have to formulate your question with a bit more detail to get a decent answer. And that's what we do, answer questions - that's a bit different from "providing codez". Like your question is standing now, I'm very inclined to explain how to add a button to the form.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]