Re: Importing data

set up spec


"Debbiedo" <deb_dolittle@xxxxxxxxx> wrote in message
news:1181264726.533039.128330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a text file that I am importing into an Access table that was
generatred from data exported from a Word file. Several (about 20-30)
fields are from check boxes on the Word form. These fields have either
0 (Not checked) or 1 (Checked). Due to requirements from a third party
software application, they HAVE to be either Y(Checked) or N (Not
checked) and MUST be a text field in the Access table.

I will be importing several thousand of these files into the Access
table so I will want to automate the process as much as possible.

I am using MS Office 2003 Suite.

I know I can import fields into a Y/N field type, display them as Yes/
No text box fields and then change them to text fields with a field
size of 1 but this is a very labor intensive task when there are 20-30
fields per file imported.

Any ideas as to how to approach this?

Thank you in advance

Debbie



.

Relevant Pages

  • form crashes Word 98
    ... All I wanted to do is create a form for people to fill-in ... It's full of check boxes and text fields and all that, but it crashes ... a Word file of some kind. ...
    (microsoft.public.mac.office.word)
  • How to get rid of e-mail toolbar in a Word 2002 file?
    ... I opened an existing Word file today, and there now appears at the top of ... the screen, below the toolbars, several boxes for ending emails (To, cc, ... The boxes do not appear in other Word files. ...
    (microsoft.public.word.docmanagement)
  • Re: Publisher 2003
    ... Is it two columns in the Word file? ... create pages and text boxes. ... Mary Sauer MSFT MVP ... get publisher to stop splitting each page in to 2 columns? ...
    (microsoft.public.publisher)
  • Re: corruption of words data, it shows boxes only instead of text
    ... i have same problem that my word file get corupted and it shows me boxes ... and i want to get back my file in original form what should i di ... "Stefan Blom" wrote: ...
    (microsoft.public.word.docmanagement)
  • Word Form issue: How to Protect and maintain the links from a Exce
    ... I'ma having a problem with a word form. ... I would like to protect a word form that I made and keep the original links ... The Word file doesn't keep the like when protected. ...
    (microsoft.public.word.docmanagement)