Re: Microsoft Excel is not a database


"Marcus Houlden" <spam@xxxxxxxxxxxxxx> wrote in message
news:slrndq1f48.2g0.spam@xxxxxxxxxxxxxxxxxxxxxxxxx
> OK, I know Excel comes preloaded on the machines at work and I know having
> a
> big table *looks* like a database, but it isn't. Want to compare a load of
> stuff across 3 tables and pull out only what you need? Tough. Want to sort
> on more than 3 criteria? No can do. Want to make sure the data is in the
> right format and you don't enter text into a number field? Good luck.

Ah. I thought I was only person who worked for a company that thought Excel
can be used as a database.

I have also been stuck with having to write scripts and stuff to get the
data into a proper database.

The other buzzword is XML. Oh, let's just use XML. That'll fix
everything.... ARRRGGHHHH.

And then when they DO try to use XML, it's completely horrid and impossible
to use!


.

Relevant Pages

  • Re: I want to load data from excel to access using xml
    ... Dim application As String, dbs As String, workgroup As String ... object and a current database you can use Application.DoCmd.RunMacro ... -uses the Commmandfunction to get the path to the XML ... have the Excel code loop until either the XML file no longer exists ...
    (microsoft.public.access.externaldata)
  • Re: import of excel data
    ... If you're importing from a database, try skipping Excel entirely. ... Use the Pivot Sheet web part (from Office Web Components). ... >> The XML web part just displays XML. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Importing / Exporting / Full application Creation Advise Please
    ... "Microsoft Office System and XML: ... into both Word and Excel from the database. ... If the Access database is converted to a SQL client server ...
    (microsoft.public.office.misc)
  • Re: Is Excel the best MS Office tool to use for this business appl
    ... I did download several of the MS Office Excel ... database for these items. ... the other end of this topic is the fact that my friend has no ... Compile and maintain my friends list of products and their cost, ...
    (microsoft.public.office.misc)
  • Re: Word 2007/Excell 2007 - random loss of field contents on mailm
    ... I think, for now, I will try to put a few dummy rows in the database while I ... the document to get data from Excel and insert it. ... use that as the data source for the merge. ... I want the field with data to insert that data in the Word doc. ...
    (microsoft.public.word.mailmerge.fields)
Loading