The answer greatly depends on your Excel version. Before Excel 2003 you could export the sheet as CSV file and import it into the database via load or a custom loader.
From Excel 2003 on you can export the sheet as XML and that, with some XML parsing code in PHP, makes it somewhat easier to import.
...jumping in here and I hardly know anything about programming but I just posted a question and in my post is the code for a registration form that uses csv.php and the data can be read in Excel 2003 in a csv file. Will this help Malli?
Hi All,
I posted this message few days ago. No one has answered so far.
I just would like to know if it is possible to do or not.
Even if you can not tell me how to do this, maybe you know which...
Hello,
I have made an small AddIn with udf for excel 2003.
I use vs2003.
The point of view is the function __T()
I call it in excel sheet writing =__T()
I am not able to set a value to a...
Hi
I would like to
1. import an existing Excel-sheet (a template)
2. and add some data to it
3. and save it under a different name afterwards.
To me it seems, that pyExcelerator does not...
hello all you gurus. I am struggling with releasing com objects. I
have isolated the problem to the code below. Objects are released and
the process ends until I
use "int k = sheet.Count;" Then...
hello,
i've just tried importing data from an excel file to a table in SQL Server 2000. there are only 887 rows in the excel file, but after the import process. and i select * from the Dest_Table....
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...