Hi All,
here's the problem! I need a table created which has the same header names repeated across the top several times. i.e spcl_loc_line, spcl_note_value, spcl_note_line, spc_note_value etc etc. To do this all I could think of doing was having my base table with my header rows as actual data within row 1. Then I could append data into this table, export as a text file without the table header rows, and my first row (my headers) would appear at the top of the text file.
However, in practice I'm finding it really annoying that Access doesnt seem to want to leave row 1 at the top!! and when an append is run, my row 1 moves into the middle of the table!!! I've tried sorting the table to make row 1 stay as row 1 but sometimes it works, sometimes it doesn't.
It's getting quite annoying now!! anyone had the same problem??
here's the problem! I need a table created which has the same header names repeated across the top several times. i.e spcl_loc_line, spcl_note_value, spcl_note_line, spc_note_value etc etc. To do this all I could think of doing was having my base table with my header rows as actual data within row 1. Then I could append data into this table, export as a text file without the table header rows, and my first row (my headers) would appear at the top of the text file.
However, in practice I'm finding it really annoying that Access doesnt seem to want to leave row 1 at the top!! and when an append is run, my row 1 moves into the middle of the table!!! I've tried sorting the table to make row 1 stay as row 1 but sometimes it works, sometimes it doesn't.
It's getting quite annoying now!! anyone had the same problem??
