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!

  • Congratulations strongm 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: bruce282
  • Content: Threads
  • Order by date
  1. bruce282

    Accessing Excel, SQL and Access in C Charp

    I've written a dozen or so small apps that read and write data in Excel, SQK Server2005, and Access using objects. I'm not a wiz but I can usually make it work. Now I need to move these programs over to C# (I have the express in my machine but can get the Professional should I need it. Before I...
  2. bruce282

    Trying to PadRight to Work

    I'm trying to incorporate .PadRight into my program. I want to make sure each text line is 574 bytes long. I've tried several things, including some suggestions from here. Below is my code. I get the following error when I uncomment the bolded line below, but the console.write works. I'm sure...
  3. bruce282

    Reformatting a Ragged Right File

    Input is a ragged right text file, not all lines are the same length. The output has to be another text file with each record being 574 bytes long. I'm a Cobol guy that's done some C and VB coding. In VB I would just open the file, read a record into deers_in (see below), then just write the...
  4. bruce282

    Finding All Columns Named SSN

    I'm trying to find all occurrences of a column named SSN in all tables in all user databases. A perfect solution would be to also alter the format of SSN to CHAR (9). Thanks, Bruce
  5. bruce282

    Can I Use SAS Arrays To Do This?

    I have a file of records that contains a 7 position id, an 8 position YYYYMMDD start date, a state code, and an YYYYMMDD end date. There can be from 1 to 30 records with the same id. I'm trying to remove overlapping dates from the file. I need to read in all records with the same id and be able...

Part and Inventory Search

Back
Top