m204prgmr Posted January 10, 2005 Report Share Posted January 10, 2005 I'm struggling here trying to figure out how to read SQL tables with ME. Has anyone been there and done that with ME. Simple stuff. Two Columns, One Rows Thanks, Robert Quote Link to comment Share on other sites More sharing options...
joe Posted January 10, 2005 Report Share Posted January 10, 2005 Native Macro Express can only read directly from a text or delimited file. You would first need to use SQL to select the records out to either a comma or tab delimited file. Quote Link to comment Share on other sites More sharing options...
m204prgmr Posted January 10, 2005 Author Report Share Posted January 10, 2005 Thanks Joe, That's what I thought. Robert Quote Link to comment Share on other sites More sharing options...
paul Posted January 10, 2005 Report Share Posted January 10, 2005 If you already have software to create and read your tables, e.g. Microsoft Access, Excel, even SQL Server, then you can get ME to drive that software, thus effectively giving you what you want. It's not difficult to write a macro that opens an Access table and returns some data. For Access and Excel, this involves learning some of the object model stuff. For SQL Server, it's simpler - use the osql utility via ME. Quote Link to comment Share on other sites More sharing options...
m204prgmr Posted January 11, 2005 Author Report Share Posted January 11, 2005 Thanks Paul, I just learned about OSQL which I'll most likely use. This allows me to stay away from setting up Jobs and DTS or Stored Procedures to get the info I need. I'll simply set up a macro to pull my one line of info from the .txt. Robert Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.