Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rfjaster

    Can't drag fields into Crystal report area

    I created a Crystal 8.5 report for a customer that has some complex joins between MS SQL database tables. I needed to make some changes to the report yesterday and did a WebEx with the customer so I could make the changes. However, when doing this, I could not insert any fields into the report...
  2. rfjaster

    Using SQL DTS .bas file in Excel

    When I was referring to SQL, I meant importing into MS SQL Server into a database table. Here is the VB code that was created when saving the DTS package from SQL Enterprise Manager: '**************************************************************** 'Microsoft SQL Server 2000 'Visual Basic file...
  3. rfjaster

    Using SQL DTS .bas file in Excel

    I am not a programmer so am not familiar with VB code. I am trying to import an Excel spreadsheet into SQL. I was able to do so using SQL DTS but I don't want the user that will be doing this in the future to have to deal with SQL. I saved the DTS package as a .bas VB file and would like to...
  4. rfjaster

    SQL query in Excel referencing an existing Excel data cell

    I am trying to create a SQL query in Excel for a customer to run and generate a report. I have the query written but would like the where clause in query to reference a cell on the spreadsheet. Basically, the customer could update the cell and the script could be updated automatically to bring...

Part and Inventory Search

Back
Top