S
Stu McLeod
Using Office 2002 and FP on win XP, when setting up excel
as a database in ODBC, should I use a system or file DSN?
And how do I name the ranges in excel so they show up
correctly using the database wizard in Frontpage?
Currently excel has two columns with col names on row one
and about 50 sheets of data with a variable number of rows
from just a few to about 150 or so. Second column has a
thumbnail graphic linked to a larger picture. Information
is static, no calculations or formulae, just need to
display the data. Could save each sheet as seperate file
if needed. Do not want to transfer data to Access or SQL,
want to be able to edit in Excel because of familiarity.
Stu
as a database in ODBC, should I use a system or file DSN?
And how do I name the ranges in excel so they show up
correctly using the database wizard in Frontpage?
Currently excel has two columns with col names on row one
and about 50 sheets of data with a variable number of rows
from just a few to about 150 or so. Second column has a
thumbnail graphic linked to a larger picture. Information
is static, no calculations or formulae, just need to
display the data. Could save each sheet as seperate file
if needed. Do not want to transfer data to Access or SQL,
want to be able to edit in Excel because of familiarity.
Stu