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 Wanet Telecoms Ltd 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: *

  • Users: edmundo
  • Content: Threads
  • Order by date
  1. edmundo

    Exporting Reports

    Hi, I have a report in MS Access (a very simple column,row report) which on a monthly basis I export to Excel. All is fine. I now need to add a new field to the MS Access report. I add the field, say in column position 10, and now export the report. The field that I have just added in MS...
  2. edmundo

    xp_cmdshell security

    Hi, one of the outputs of a stored procedure I have written creates a text file. I have achieved this by using xp_cmdshell in conjuntion with a bcp command. My question surrounds security. Because of the mixed environment we have in our company I have found it easier for the time being to use...
  3. edmundo

    Extracting Patterns from a String

    Assume I have a 2 column table. AlrmCode,AlrmText AlrmText actually contains data that I need to display as different rows. An example of the information that is kept in the table is: AlrmCode,AlrmText 2154,*alarm info 1 *alarm info 2 *alarm info3 2178,*alarm info 4 *alarm info 5 But I...
  4. edmundo

    Data import from Excel using DTS

    Hi, I'm trying to import data from an Excel spreadsheet.One of the fields in the spreadsheet is a comment field which is often greater than 255 characters. On importing the data to SQL, this field concatenates at 255 chars. It doesn't matter whether I create the import table up-front with the...

Part and Inventory Search

Back
Top