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
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!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.