Lost Newbie ...SQL and other sorrows
Hmmm
Source
"Before you can choose an ODBC data source, you must specifically create the
data
source by binding your data file to a driver. You can do this in the Windows
ODBC
Data Source Administrator, found in the Control Panel as 32bit ODBC. After
you
create the ODBC data source, you can select it in NetObjects Fusion."
For a couple of days now, I have read everything my search engines could
find on just how to do this and I think I have installed a whole lot of
stuff I don't need in the hope that something would 'click' (in my brain
more than on my machine!)
I know this is not Fusion's problem... but maybe someone here can point me
to a reeeeeeally basic starting point.
All I want to do is...
Create a local site that links to a local Excel spreadsheet as a way of
displaying the each record on a separate page
Basically the sheet is product records, has 5 fields, (product, price,
description etc) so I just need to use a one column, five row table and a
query that will populate with name in the first cell, price in the second
and so on.
However, I get to the ..."You can do this in the Windows ODBC
Data Source Administrator, found in the Control Panel as 32bit ODBC... " bit
as previously mentioned, and don't know what tabs and drivers to choose what
to put in the bloomin' boxes for this local situation.
Any answer, (and I'm begging now) can assume I now have every possible (and
probably redundant) driver installed.
Yours pathetically
PQ
wsp Christopher
Okay, I can only make a suggestion on the information that is provided here.
Regarding Excel it really is not a database; it is a spreadsheet program you
would either need to place the information into a database be it Access or
MySQL or SQL; before you could use the information.
Once in the database you could then utilize the language to search the
information.
Another way of doing this would be to export the information into comma or
other character delimited flat file and then utilize perl. However, as
stated just a suggestion.
There are multiple ways of doing databases, and a multitude of both
programming languages and database structures. The only viable information
if you do not except the rest of the information on this email is to first
write doen the functions you would like your database to be able to perform.
Then determine if this database will have a growth period and if so
approximately within what timeframe and approximately how large will the
growth be. Then with that information look over each possible method for
language use and database structure used to find possibilities of matching
the abilities and growth potential.
You will still find after this process usually between one and three
methods. Then you have to either choose or test each one for speed.
If I can be of any further assistance; please feel free to contact me.
Sincerely,
WSP Christopher
"Hmmm" <pq...@bigfatnospam.ozemail.com.au> wrote in message
news:bnfrp0$jr...@news01.netobjects.com...
Stephen Russell
> Create a local site that links to a local Excel spreadsheet as a way of
> displaying the each record on a separate page
> Basically the sheet is product records, has 5 fields, (product, price,
> description etc) so I just need to use a one column, five row table and a
> query that will populate with name in the first cell, price in the second
> and so on.
> However, I get to the ..."You can do this in the Windows ODBC
> Data Source Administrator, found in the Control Panel as 32bit ODBC... "
bit
> as previously mentioned, and don't know what tabs and drivers to choose
what
> to put in the bloomin' boxes for this local situation.
I have a sheet with this data.
pa_page pa_bolt
ALL-10 80
CHL-1 80
NSD-7 60
TRE-1 60
I want to see all pa_bolt's with a value of 60 (NSD-7 and TRE-1)
Start|Control Panel|Administrative Tools|Data Sources
Click on Add. Choose Excel worksheet. Click on Choose Workbook. Pick the
file with your data. Name this sucker so you will understand what it is!!!
From any other Winders app you can fetch this data. Word, Access, FoxPro,
SqlServer,.....
--
Stephen Russell
S.R. & Associates
Memphis TN
901.246-0159
Steve says get rid of the notat_ to send him a reply!
Steve says get rid of the notat_ to send him a reply!
"Hmmm" <pq...@bigfatnospam.ozemail.com.au> wrote in message
news:bnfrp0$jr...@news01.netobjects.com...