no they didnt use the create table ddl..
will that actually prevent you from storing anything in an number field
that isnt a number?
like i can specify a long int-- like in Access?
I told you already, Excel Jet doesn't have an INTEGER data type. It's
only numeric type is FLOAT (double precision floating point). So using
FLOAT in DDL:
CREATE TABLE [Excel 8.0;DATABASE=C:\test2.xls;].Aaron (test_column
FLOAT);
INSERT INTO [Excel 8.0;DATABASE=C:\test2.xls;].Aaron VALUES ('two');
Data type mismatch in criteria expression.
The INSERT fails because the value 'two' is non-numeric. Do you see how
Excel Jet data typing works if you use it properly.
We've determined that your spreadsheet was not designed to be used as a
Jet data source. Aaron, stop using it as if it were a proper database.
Use a spreadsheet as a spreadsheet. Learn some Excel VBA and you'll be
a happier person. If you are being asked to do something against your
principles then quit, people will respect your for that and your will
gain self respect too. Do you see yourself as a DBA (database
administrator)? Then go for it, don't bother with these spreadsheets if
they make you unhappy.
find me a manager that is decent with databases-- and i'll go to work
for them for free.
i just think that 50% of the workplace in corporate america uses Excel
all day long.
I am a manager and I'm more than decent at database and spreadsheets
and spreadsheets-as-databases. In my organization, we use Excel
properly but we are not an American corporation. Why do you think this
is an American problem?
You've lost me with the rest of your rant though. Good to get it off
your chest, eh?