Search results

  1. W

    how do i tabulate a list into 2 columns in a text file?

    I have a table full of data i need to extract and place into a text file. I can do this no worries, but what else is required is to place the extracted data into 2 columns in the text file, this is what i cant work out how to do. here is what i have below Sub CreateBulletinList() Dim db...
  2. W

    programatically import a text file into access 97? cant work it out.

    cause the etext file has varying headings that i cant get around by other than code. any way i have worked it out and got it all working using vba.
  3. W

    programatically import a text file into access 97? cant work it out.

    i need to be able to have an access 97 database import a text file with a click of a button. the text file is in a tab delimited format and i cant work out how to do this. sample of the text file below, i only need to get the part where the numbers are and nothing above it in the database. it...
  4. W

    Excel into access and vertical columns? how?

    ok i get ya what ya mean but its not totally what im after as it wont work for my application. what i want to do i dont think i can do with access without a lot of messy coding. it needs to reset this data ever month and the old data needs to be stored. for what its worth i think it is far...
  5. W

    Excel into access and vertical columns? how?

    no your not listening, i DONT WANT TOalter tables, i WANT TO ALTER FORM, increase columns in form dynamically like what automatically happens with rows.
  6. W

    Excel into access and vertical columns? how?

    no that is not what i want and wont work. i need to dynamically create more rows and columns. rows come automatically with a continuous form, but how do you icrease the number of columns in a form like you do with rows? can it be done? e.g. add a new client(row) access will just tack it on...
  7. W

    Excel into access and vertical columns? how?

    i have an excel sheet that needs to be put in access 2000 and i cant work out how to do it. as in the attached image i need to be able to have grouped rows across the top in a vertical manner and a user definable number and also have the company name down the side, again a user definable number...
Back
Top Bottom