User Profile

Collapse

Profile Sidebar

Collapse
jason2412
jason2412
Last Activity: Jan 29 '08, 09:34 AM
Joined: Mar 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jason2412
    replied to Export data to sequential file
    in Access
    Pasted the code in the click event of a command button but got a file/path access error. When I go into debug it highlights the line 'Open "C:\Sequential. txt" For Output As #1'.

    I created a folder in my C: called sequential...wa s that the right thing to do?

    Not very good with visual basic etc so not sure why that last line of code is not working.

    Ps...cheers to all for the help, appreciated!
    See more | Go to post

      Leave a comment:

    • jason2412
      replied to Export data to sequential file
      in Access
      ADezii - Thanks for the code. Do I just copy this into a module? Just not sure how I use the code so that I can see the text file generated.
      See more | Go to post

        Leave a comment:

      • jason2412
        replied to Export data to sequential file
        in Access
        Yes, I can see how I confused the matter when I included an example with commas.

        For clarity:

        Field 1 - Retail
        Field 2 - Sat
        Field 1 - Direct
        Field 2 - Sun

        The required output for the above example would be:

        Retail#SatDire ct#Sun

        So a hash is added after field 1 and a carriage return () is added after field 2. All the data would run sequentially (left...
        See more | Go to post

          Leave a comment:

        • jason2412
          replied to Export data to sequential file
          in Access
          Maybe I am not being clear. I dont need help with the export function...i.e tab delimited etc. I need help creating a sequential file.

          Example:

          Field 1, Field 2
          Field 1, Field 2
          Field 1, Field 2

          The above is an example of exporting the file. What I need is the file to look like:

          Field 1, Field 2, Field 1, Field 2, Field 1, Field 2

          So all records run one after...
          See more | Go to post

            Leave a comment:

          • jason2412
            replied to Export data to sequential file
            in Access
            Yes, has to be a hash as a script then reads the text file. Can this be done...i.e so the output is not column by column but reads across the way? I have tried looking around for a solution but have drawn a big blank....
            See more | Go to post

              Leave a comment:

            • jason2412
              started a topic Export data to sequential file
              in Access

              Export data to sequential file

              Hi,

              Not sure if this is the right place to post this query so apologies in advance.

              I have two columns in an access table.

              Example for 2 records:

              Field 1 - Retail
              Field 2 - Sat
              Field 1 - Direct
              Field 2 - Sun


              Can someone tell me how you output this as a sequential file? So the text file reads Retail#SatDire ct#Sun ...so that a hash is inserted...
              See more | Go to post
              No activity results to display
              Show More
              Working...