467,114 Members | 1,338 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,114 developers. It's quick & easy.

Importing data

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
  • viewed: 2262
Share:
2 Replies
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
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.

Similar topics

11 posts views Thread by Grim Reaper | last post: by
7 posts views Thread by Darren | last post: by
7 posts views Thread by Timothy Shih | last post: by
reply views Thread by Mike Collins | last post: by
2 posts views Thread by Mike Collins | last post: by
5 posts views Thread by hharriel@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.