473,396 Members | 2,018 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Is it possible to use an Excel sheet as a Database

Hello Everyone,

I'm a starting web programmer. I'm making a website for an Irish Pub.
Because of the many different activities in the pub I'm searching for
a possibility to give away some tasks to other people who don't know
anything about webprogramming. For results of tournament etc. I wanna
make an excel sheet to fill in the results by poeple who don't know
webprogramming. Is it possible to import data from an excelsheet into
a php file. In this way I can make my own template with the imported
data from the excel sheet.

Grtz Luuk Krijnen
Jul 17 '05 #1
3 7166
"Luuk Krijnen" <kr*****@globe.nl> wrote in message
news:a6**************************@posting.google.c om...
Hello Everyone,

I'm a starting web programmer. I'm making a website for an Irish Pub.
Because of the many different activities in the pub I'm searching for
a possibility to give away some tasks to other people who don't know
anything about webprogramming. For results of tournament etc. I wanna
make an excel sheet to fill in the results by poeple who don't know
webprogramming. Is it possible to import data from an excelsheet into
a php file. In this way I can make my own template with the imported
data from the excel sheet.

Grtz Luuk Krijnen


Why not make a form on the website they fill out, this way the data goes
right into your site, instead of them typing into excell (in the format you
have to tell them, [over and over] ) and then you having to import this into
the site.
--
Mike Bradley
http://gzen.myhq.info -- free online php tools
Jul 17 '05 #2
nbd
> Hello Everyone,

I'm a starting web programmer. I'm making a website for an Irish Pub.
Because of the many different activities in the pub I'm searching for
a possibility to give away some tasks to other people who don't know
anything about webprogramming. For results of tournament etc. I wanna
make an excel sheet to fill in the results by poeple who don't know
webprogramming. Is it possible to import data from an excelsheet into
a php file. In this way I can make my own template with the imported
data from the excel sheet.

Grtz Luuk Krijnen


You can save the sheet as .csv, and then read .csv from php to do something
with the values. It's a nice manner to export data from excel to php

-nbd-
Jul 17 '05 #3
nbd
> Hello Everyone,

I'm a starting web programmer. I'm making a website for an Irish Pub.
Because of the many different activities in the pub I'm searching for
a possibility to give away some tasks to other people who don't know
anything about webprogramming. For results of tournament etc. I wanna
make an excel sheet to fill in the results by poeple who don't know
webprogramming. Is it possible to import data from an excelsheet into
a php file. In this way I can make my own template with the imported
data from the excel sheet.

Grtz Luuk Krijnen


It's possible and is an easy way saving the sheet as .csv and then read .csv
from php to do something with result data.

-nbd-

Jul 17 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Allison Bailey | last post by:
Hi Folks, I'm a brand new Python programmer, so please point me in the right direction if this is not the best forum for this question.... I would like to open an existing MS Excel spreadsheet...
9
by: Edward S | last post by:
I budget for a Project in an Excel sheet as illustrated below. The months below are usually a 2 year period i.e. 24 months, though it could be over 24 months depending upon a Project. I then...
0
by: ImraneA | last post by:
Hi there Have a database, where front-end interface allows user to select a ms access database. From there, standard tables are linked. Routine, that creates a spreadsheet, for each table a...
2
by: Ian | last post by:
I have an Access97 database and I am trying to create an Excel sheet from a report within this database. I have the following code on the On Click event of a button on a form: ...
3
by: Mads Petersen | last post by:
I'm stuck in this code. Hope you can and will help me. I launch it from excel. I have made the following code work, but not as i whant. I need the ranges to be working with something like xlDown....
1
by: Vivek | last post by:
Hi all, I am trying to import data from an excel sheet to MSSQL server 2000 using a web application (C#). Since I have to validate the data in the excel sheet, the approach i have used is to get...
0
by: franjorge | last post by:
Hi, I have created two stored procedures via VB using this code: sql = "CREATE PROC " & nombre_proc & " AS SELECT *" & _ " From MBM_PUNTOS_SCE_SIN_COINCIDIR_SIEGE_FALTA_PM_NE_" & mes & _ "...
7
by: TG | last post by:
hi! I am trying to create a sql server table from an excel sheet. Here is the code I have: 'This procedure the xlsx file and dumps it to a table in SQL Server
1
by: =?Utf-8?B?QWRyaWFuTW9ycmlz?= | last post by:
Hello All, I am trying to read an Excel spreadsheet (xls) programmatically. I have used the ODBC database route and have opened the Excel spreadsheet and then using a 'CRecordset', I read each...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
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...
0
tracyyun
by: tracyyun | last post by:
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...
0
agi2029
by: agi2029 | last post by:
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.