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 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: *

  1. newpgm

    Converting Text value to decimal value

    I am using CDec but it is not working.. In my table I defined ct_num as decimal with precision as 7 and scale as 2 when I run this it shows error message 3759 " Scaling of decimal value resulted in data truncation. ct_num=CDec(ct_val) If I use CInt or CLng it is rounding the number. say...
  2. newpgm

    How can I read 3rd row first field of my csv spreadsheet using VBA

    where do I specify the row number and field number in docmd.transfertext. Also how can I store this value into a table
  3. newpgm

    Reading CSV file using VBA-- specific rows and columns with datatypes

    I need to read a csv file.. Sub import_csv() DoCmd.TransferText acImportDelim, "", "Test_CSV", "c:\csv_files\12-31-2009 Test.csv", False, "" End Sub but my code is not successful, because one of my field some times has numbers values and other times it have character values so this field is not...
  4. newpgm

    Reading specific rows and columns fron .csv files using ACCESS VBA

    My .csv is imported into a table. Now using VBA code how can I read R29C2:R150C4
  5. newpgm

    Reading specific rows and columns fron .csv files using ACCESS VBA

    I want to do some thing like below. Sub TEST_ImportCSV() strFilePath = "G:\" strFileName = "12-18-2009 Panel " & ".CSV" strQuery="qryImport" DoCmd.TransferText acExportDelim, , strQuery, strFilePath & strFileName, False end sub but how do I replace my file name with the parameter entered in...
  6. newpgm

    Reading specific rows and columns fron .csv files using ACCESS VBA

    sorry for the confusion. My code is in SAS not Access. I have to start brand new module. *let csv_file=Mountain plate1 12-12-2009.csv; %macro file_name (dsn=); options mprint mlogic symbolgen NOXWAIT NOXSYNC ; x "start excel"; options missing =0; data _null_ ; x = SLEEP(3) ; run ...
  7. newpgm

    Reading specific rows and columns fron .csv files using ACCESS VBA

    Hi All, I have a csv file and I have to create a table by reading specific rows and columns from the csv file. I would like to do this using VBA.. 1) I have to read 1st rows 1 st column after colon as my filename field ( Document Name: 12-18-2009 Panel xls ) 2) Then I have to read 8th row, 2nd...

Part and Inventory Search

Back
Top