Import data from Word table into Access

  • Thread starter Thread starter Gordon Padwick
  • Start date Start date
G

Gordon Padwick

I've created an Access database that's used to record hours volunteers
contribute to a Master Gardener program. At present, indivudual Master
Gardeners report their hours on a paper form. Data from those forms is
manually transcribed into the master Access database.

In an effort to somewhat automate this process, I've created a Word form
template that individual Master Gardeners who have Word can use to create
forms in which they can record their hours. My thought is that individual
Master Gardeners can e-mail their forms to the office where the data on
those forms can be automatically added to the master Access database.

I've gone this far. My template can be used to create individual forms.
Individual Master Gardeners can use those forms ti record their contribuited
hours. The forms can be e-mailed to the office. At the office, a computer
can be set up to save only data from the forms. However, the saved data
appears as a comma-delimited file with no separation between the rows of
data in the original Word table.

My Word table has a specific format, so I know how many fields are in each
row (17). How can I import data from the comma-delimited file so that a new
row in the Access table is created after each 17 fields? Is it necessary to
pre-process the comma-delimited file to insert a marker (CR?) after each 17
fields? If so, how could I do that?

I'll appreciate any suggestions.

Gordon
 
look at :
DoCmd.TransferText
You will need to know the path of the file you are importing. The help
files should explain it to you.
 
Thanks, for the reply. Unfortunately, you don't address my problem.

My problem is that the comma-delimited file has no separation between the
rows of the original Word table. Consequently, when Access attempts to
import the file, it displays an error message after importing data for the
first row into the target Access table

Is there a way for Word to save data from a table in a comma-delimited file
that includes a special character (such as CR) that separates each row of
the table from the next? If that can't be done, how can I process the
comma-delimited file to insert a row-terminating character after every so
many (17 in my case) fields?

Gordon Padwick
 
Back
Top