Re: Vlookup nightmare

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

well the thing is that SQL is portable

and Excel is a dead end street

you can take your logic out of an Access database and move it to SQL
Server; mySql-- oracle; anythign else in the world.

but Excel-- is a dead end street. and Excel is a disease.

50% of corporate America uses Excel every day-- making the same report
week in and week out
and my mission in life is to kick them out of employment.

-aaron

ps - databases can do anything that excel can; even better-- and MDX
just blows Excel out of the water.
MDX has taken over the world and Excel dorks are too lazy to grow into
the future

.

Relevant Pages

  • Re: SQL Server CE data transfer
    ... There is no direct way for you to send Excel data to a SQL CE database. ... you can convert it into an Access database, then you have a chance of ... > Users will download an excel file from our web site to a desktop computer ...
    (microsoft.public.pocketpc.developer)
  • Re: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)
  • RE: populate some userform fields from access database
    ... Take a look at a similar link posted earlier today, titled: ADO copy from SQL ... Server into Excel 2003 List Box. ... access database based on what I put in Student_ID field. ... Dim cn As Object ...
    (microsoft.public.excel.programming)
  • RE: Macro
    ... Then post the query results. ... My data is in an Excel file called ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ... VBA code in excel suddenly became un-compileable. ...
    (microsoft.public.excel.programming)
  • Re: Question for Joe Fallon--determining Data type
    ... then the data type for the column will be Text. ... means 255 characters max (that's a Jet limit). ... where MSDE or SQL Server is the main database (in these cases Jet ... Is 'Spreadsheet' an MS euphemism for 'Excel' or does it support other ...
    (microsoft.public.access.externaldata)