Data Tracking Template Wizard

  • Thread starter Thread starter gregork
  • Start date Start date
G

gregork

I'm using the template wizard in excel to send data from cells in my
spreadsheet to a database. The problem I have is I want to send data from
more than one cell under a field name in the database. The wizard will only
accept one cell per field name. My spreadsheet is like an order form I want
to set as a template and I want all the individual products and their
quantities recorded individually in rows on a database. How can I do this?

regards
gregk
 
gregk

Unfortunately, the built-in data tracking feature does not allow for this.
I think your options are these:

1. Concatenate all the "detail" lines on your order into one long string
and save that into one field in the database. Then, whenever you need those
details, use code to split that line into it's components.

2. Don't use data tracking and write your own data tracking macro that does
what you want.

The first option would be relatively easy, but probably not very useful.
The second option would not be so easy, but once it was done you wouldn't
have to mess with it again.
 
Back
Top