Search results for query: *

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

Thank you so much, but I am afraid I do know know how to enter this formula. Do I do this within my Cross tab as a calculated member?

I believe that you can remove the line AND g.action_dt between '01-Jan-2009' AND '31-AUG-2009' from your SQL. Then create a parameter field for the start date and the end date. Then go to the seleciton expert choose records and new, choose the date field, you will then choose formula down...

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...

Thanks for the information. I ended up adding the excel commands under references http://support.microsoft.com/kb/198571 and using get file similar to: http://www.ozgrid.com/VBA/ExcelsDialogBoxes.htm Take care

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!