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!
-
How to import a txt file based on position
How can I import a flat text file into a sql table SQL based on position? As an example Field Name Start Width Positions Column 1 1 6 1-6 Column 2 7 9 7-15 Column 3 16 9 16-24 Column 4 25 9 25-33 Ignore Column 5 33 4932 33-5286- kat50
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Data Transformation Services
-
How to total a Calculated Member
I have created a calculated member based on my grand total (left) that I named Second Fee where I say if (GridValueAt (CurrentRowIndex,CurrentColumnIndex -1 ,CurrentSummaryIndex) >1 ) then 10 else 6 How can I get a total of this column("Second Fee")? When I right click on the summary it is...- kat50
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
TransferSpreadsheet Import access2002
Can someone help me create the VB to import a spreadsheet the catch is I want to be able to choose the file and not have it defined. I only know how to use the macro feature to set up the transfer spreadsheet but that requires a sepcific file name be impoorted each time. Thanks a million!- kat50
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
