code to make new sheet with data rearranged

  • I have a client that uses Excel as a database and I have developed an Access database that prepare reports and other things with at least a portion of the data they have in the Excel Sheet.

    The Access database allows data to be imported from a tab delimited file.

    I'm just wondering if there are any utilities, macros or code that would simplify the creation of delimited files from their worksheets. I have't analyzed the Excel sheets, but for sure not all the columns would have to be used and they would have to be rearranged and probably some repetitive data might have to be copied into each row.

    Thanks in advance

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!