Re: Form data output

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Gobi,

> Not really a VBA issue but...
>
> 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 so that it triggers a new
> row?
>
It's not possible to change that output. Nor can I envision how Access
should deal with the format you propose, as each "row" would have the
same field name, thus creating multiple records...

The best solution would probably be to either use automation from within
Access to extract the data from Word or the text file (ADO or DAO
connection). Or to use DAO or ADO to put the data directly from Word into
the database.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

.

Relevant Pages

  • Re: Create Table Example in asp
    ... of your DAO code to ADO. ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.scripting.vbscript)
  • Re: A common problem : ADO vs DAO slower
    ... Dave Patrick ....Please no email replies - reply in newsgroup. ... | we have migrated our application that uses an MS Access database from DAO ... | Now we encounter the most common problem: ADO is slower than DAO. ...
    (microsoft.public.data.ado)
  • Re: Speed of working on Access tables
    ... What ADO supports depends on what the OLE DB provider for the database ... I know the DAO ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.office.developer.automation)
  • Re: Importing data From Word Form to Access
    ... you have DAO and ADO. ... > access database. ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.docmanagement)
  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)