G
gobi
I've got a really long form (~50 pages) template. I need to export the
data into Access and I know the standard output method for saving as a
CSV file. But, since Word exports the data as a single row of comma
separated data, and the form has around 400 inputs, this blows the
capacity of Access to import. What I'd like to do is insert some kind
of break in the form -- without creating separate forms -- that will
take the first 50 inputs and put them in a row, put the next 50 in a
row, and so on. So, anyone have any good ideas on how one can
manipulate the "save data for forms" output?
data into Access and I know the standard output method for saving as a
CSV file. But, since Word exports the data as a single row of comma
separated data, and the form has around 400 inputs, this blows the
capacity of Access to import. What I'd like to do is insert some kind
of break in the form -- without creating separate forms -- that will
take the first 50 inputs and put them in a row, put the next 50 in a
row, and so on. So, anyone have any good ideas on how one can
manipulate the "save data for forms" output?