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 bkrike 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: lhrpa
  • Content: Threads
  • Order by date
  1. lhrpa

    Want to change connection string in Excel query

    Hello there! I have a workbook that pulls data from a SQL Server 2000 database using several different queries for different parts of the workbook. I built the queries using the "New Data Query" option in Excel and I have the query properties set to refresh on open. Everything works...
  2. lhrpa

    Autofill method of Range Class Failed

    Help (again!) I'm trying to autofill a column of data with a sequence number. I can find the range I need to fill no problem (thanks to the wonderful FAQ section :-) ), but for some reason I'm getting an error on my autofill. Any suggestions? Thanks a million! Linda Sub fillit() Dim...
  3. lhrpa

    Save copy of spreadsheet after refreshing data from SQL Server

    Hello there! I have a spreadsheet that on file open will refresh data from SQL Server into the spreadsheet. I want to be able to save and keep that data in a spreadsheet as of that point in time. If I do a "Save As", it of course saves the spreadsheet with the queries, and then the...
  4. lhrpa

    left pad a column with zero

    I need to load a numeric column into a varchar(12) column, and I need to left pad with zeros. The numeric values could be of varying lengths from 5 - 11. For example, a 12345 from my input data file needs to look like 000000012345 once loaded into the table column. Does anyone know a good...
  5. lhrpa

    Determine last day of the month

    I would like to be able to compare a date within my data to the last day of the previous month, is there a last day function of some sort in SQL Server? Thanks for any guidance! Linda

Part and Inventory Search

Back
Top