Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
A "Poor Man's" Database is all I really want
Old 11-02-2006, 04:11 PM A "Poor Man's" Database is all I really want
Junior Talker

Posts: 4
Name: Patrick
Trades: 0
Here's what I'd like to do. I would like to take data from a
microsoft excel spreadsheet and have it automatically get plugged into
my website template and create a new webpage. I want each row of
data/information on the spreadsheet to appear on a new webpage on my
website. 1 row of data = 1 new webpage.

I want each webpage it creates to have my website's template/colors,
borders, navigation links, etc.

So basically a spreadsheet row might have the following information:

Column A, Row 1: Dallas Use Cars, 200 Main St, Dallas TX, 90276
Column B, Row 1: 905-548-5588
Column C, Row 1: www.dallasusedcars.com
Column D: Row 1: Used Cars Sales

I want a program that can automatically take thousands of these rows
and create webpages with that information on them. I will have much
more than 3 or 4 cells of data. I want to be able to specify where
the particular cell will go on the webpage (ie. Colum D cells creat
Title Tags).

So basically if I have 2000 rows of information, this program would
create 2000 unique webpages. Plugging in the data from specified
cells into a predesigned webpage template and creating a webpage.

I'm not too familar with MySQL or online databases, which is where I
suspect you may go with this. Ideally I'd be just fine if I could
create the webpages all locally on my PC, and simply upload them to my
webhost and be done with it. I'm not looking to manage this
information or update it every month, etc. Of course some sort of
sitemap or directory page would need to be created in the process, so
each page could be found.

Any thoughts anyone?

I am definately not a programmer, so I'd be happy to buy a software
program if it could do this - assuming its not too expensive.
jd1976 is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 11-02-2006, 04:22 PM Re: A "Poor Man's" Database is all I really want
kreoton's Avatar
Extreme Talker

Posts: 194
Trades: 0
everything can be found on google i gues you wrote this text about 10 mins i wrote this ( http://www.google.lt/search?hl=lt&q=...%C5%A1ka&meta= ) search quory in 10sec
__________________

Please login or register to view this content. Registration is FREE
|

Please login or register to view this content. Registration is FREE
kreoton is offline
Reply With Quote
View Public Profile Visit kreoton's homepage!
 
Old 11-02-2006, 04:27 PM Re: A "Poor Man's" Database is all I really want
Junior Talker

Posts: 4
Name: Patrick
Trades: 0
Wow!! Thanks - you're confident that this can do what I need it to?

Thanks!
jd1976 is offline
Reply With Quote
View Public Profile
 
Old 11-02-2006, 04:34 PM Re: A "Poor Man's" Database is all I really want
kreoton's Avatar
Extreme Talker

Posts: 194
Trades: 0
Quote:
Originally Posted by jd1976 View Post
Wow!! Thanks - you're confident that this can do what I need it to?

Thanks!
This one ( http://www.excelreader.com/ ) is with online demo, so try your self
__________________

Please login or register to view this content. Registration is FREE
|

Please login or register to view this content. Registration is FREE
kreoton is offline
Reply With Quote
View Public Profile Visit kreoton's homepage!
 
Old 11-02-2006, 04:38 PM Re: A "Poor Man's" Database is all I really want
Junior Talker

Posts: 4
Name: Patrick
Trades: 0
Hmmm, ok, what I want though is for each row of my excel spreadsheet to be displayed on a separate webpage.

I got a "fatal error" trying to parse - from the first website demo...
jd1976 is offline
Reply With Quote
View Public Profile
 
Old 11-02-2006, 04:42 PM Re: A "Poor Man's" Database is all I really want
Defies a Status

Posts: 1,605
Trades: 0
Quote:
Originally Posted by jd1976 View Post
Wow!! Thanks - you're confident that this can do what I need it to?

Thanks!

That first link I tested with a sample excel file I had on my computer. It recreated an html page that looked exactly like the spreadsheet columns.

That may be good or bad for you. It is a free download and use for 2 weeks. I don't see where you have anything to lose by trying it. Just be sure to work with a copy of you file. I guess you could lose your data.
__________________
Colbyt

Please login or register to view this content. Registration is FREE
colbyt is offline
Reply With Quote
View Public Profile
 
Old 11-02-2006, 04:44 PM Re: A "Poor Man's" Database is all I really want
Junior Talker

Posts: 4
Name: Patrick
Trades: 0
I guess what I was looking for was a program that will create a separate webpage for each row within my database...
jd1976 is offline
Reply With Quote
View Public Profile
 
Old 11-02-2006, 06:58 PM Re: A "Poor Man's" Database is all I really want
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,520
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
convert your Excel sheets into Access mdb files it will be much simpler to code a script to read an Access record and create pages from that than it is from Excel.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 11-03-2006, 10:36 AM Re: A "Poor Man's" Database is all I really want
Average Talker

Latest Blog Post:
5000 Web Directories
Posts: 15
Trades: 0
Import them into a database, read from them, plug the data to a page generating script using a template. I'm sure someone can do that for you here.
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
j4s0n is offline
Reply With Quote
View Public Profile Visit j4s0n's homepage!
 
Old 11-06-2006, 06:06 PM Re: A "Poor Man's" Database is all I really want
EngAdven's Avatar
Experienced Talker

Posts: 37
Name: Gary Molton
Trades: 0
DB to HTML express from www.xlinesoft.com will export data from any spreadsheet or database into pure html via a simple template.
ASP runner again from xlinesoft also works with excel for a dynamic online solutions but I'm not sure how.
Also www.straight2web.net will let you import tab delimited files from a spreadsheet and build these straight into an html table format again using a simple table template code.
__________________
Gary Molton - Engineering Adventures Ltd

Please login or register to view this content. Registration is FREE
-
Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
-
Please login or register to view this content. Registration is FREE
EngAdven is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to A "Poor Man's" Database is all I really want
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.30516 seconds with 12 queries