By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,689 Members | 1,731 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,689 IT Pros & Developers. It's quick & easy.

Importing data

P: n/a
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

Jun 8 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
set up spec
"Debbiedo" <de**********@yahoo.comwrote in message
news:11**********************@r19g2000prf.googlegr oups.com...
>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

Jun 8 '07 #2

P: n/a
On Fri, 08 Jun 2007 01:05:26 -0000, Debbiedo <de**********@yahoo.com>
wrote:

So import into a "temp" table and then use an append query to import
into the "real" table, in the process converting from 0,1 to n,y.

insert into tblRealTable(fieldYN1, ...)
select Choose(FieldYN1, "N", "Y")
from tblTempTable
(lookup the Choose function in the Help file)

As ECOOK mentioned (tersely), you may be able to set up an Import
Specification to do the same. Import the text file, and save the
specs. Later on, you can use the saved specs in DoCmd.TransferText

Note that the display of a value has little to do with how it's
stored. Also note than in VBA, True has a value of -1, not 1. But it
will typically work because True is also (NOT False).

-Tom.

>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
Jun 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.