Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Tracking Template Wizard
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. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "gregork" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template Wizard w/Data Tracking | Excel Discussion (Misc queries) | |||
Template Wizard with data tracking | Excel Discussion (Misc queries) | |||
Template Wizard with Data Tracking | Excel Worksheet Functions | |||
Template Wizard with Data Tracking | Excel Discussion (Misc queries) | |||
Template Wizard with Data Tracking | Excel Discussion (Misc queries) |