B
bene
Hello,
I am looking to export an Access table to Excel with it automatically
inputting lines between entries. The tricky part is that I want the
number of lines between entries to be determined by a column of the
table.
Example:
People City State
4 Los Angeles CA
1 Denver CO
7 New York NY
3 Washington DC
2 Juno AL
When it exports, I need it to put 4 lines between the Los Angeles row
and the Denver row, 1 line between the Denver row and the New York row,
etc.
I couldn't do it through a conventional export, any thoughts on a VB
code that would work? Thanks.
I am looking to export an Access table to Excel with it automatically
inputting lines between entries. The tricky part is that I want the
number of lines between entries to be determined by a column of the
table.
Example:
People City State
4 Los Angeles CA
1 Denver CO
7 New York NY
3 Washington DC
2 Juno AL
When it exports, I need it to put 4 lines between the Los Angeles row
and the Denver row, 1 line between the Denver row and the New York row,
etc.
I couldn't do it through a conventional export, any thoughts on a VB
code that would work? Thanks.