J
Jeannie Slater
Hi, thanks in advance for any help.
I have been working with Access for 12 years. I think I know quite a bit
but this simple issue has me stumped. I have done hundreds of imports and
have been able to solve any issues. A task I need help with--via the
internet, I import a listing from our dept. that handles telephone charges.
Available on their site is an option to import in CVS format. The only other
option is PDF. The WEB site displays an icon that looks "like" the Excel
icon. I import and save it to my desktop changing from CVS to Excel. (I put
it on my desktop as it is temporary and does not need permanent storage.) I
return to Access and attempt to import the file. First time doing this I
just let it import in the formats it chooses and let the import set up the
table. I do this only the first time simply to save myself the pain of
setting up the table from scratch. I then change some of the formating on
the fields (usually from number to text.) I strip out the data leaving
myself with the empty table. I figure from this point on the import should
go like a breeze. So, I have an empty table that has 20 fields. 17 of the
fields are text because of the way that department had set up their data. Of
the 17 text tables only 1 is causing me a problem. It's contents are not
much different from the other 16 text field's contents. Now I import the
actual records. There are 2300 records of which the import finds 37 and
isolates them in the "import errors" table. These 37 records happen to be
blank in this field. But of the 2300 records, there are actually 202 records
that are blank in this same field yet it shows 37 to be bad. Import did not
include the other 165 records in its error table. Import does not strip any
of the contents out of that field, just alerts me that 37 are stinky. Even
when I have that particular field set for text, import still shows error and
sets up an error table. I cannot see any reason for this particular field to
not import correctly. Other fields can have some blank contents, but they
are set up for text, and import just fine. The 37 blank fields are grouped
together but others that are also blank are scattered in the field. Is there
a way I can tell the field on the table to accept anything because it is set
up for text? Or, is there a way I can delete the error table without have to
go to the into the underbelly of the database? Other people will be working
with this data and I don't want them in that area. Thanks
I have been working with Access for 12 years. I think I know quite a bit
but this simple issue has me stumped. I have done hundreds of imports and
have been able to solve any issues. A task I need help with--via the
internet, I import a listing from our dept. that handles telephone charges.
Available on their site is an option to import in CVS format. The only other
option is PDF. The WEB site displays an icon that looks "like" the Excel
icon. I import and save it to my desktop changing from CVS to Excel. (I put
it on my desktop as it is temporary and does not need permanent storage.) I
return to Access and attempt to import the file. First time doing this I
just let it import in the formats it chooses and let the import set up the
table. I do this only the first time simply to save myself the pain of
setting up the table from scratch. I then change some of the formating on
the fields (usually from number to text.) I strip out the data leaving
myself with the empty table. I figure from this point on the import should
go like a breeze. So, I have an empty table that has 20 fields. 17 of the
fields are text because of the way that department had set up their data. Of
the 17 text tables only 1 is causing me a problem. It's contents are not
much different from the other 16 text field's contents. Now I import the
actual records. There are 2300 records of which the import finds 37 and
isolates them in the "import errors" table. These 37 records happen to be
blank in this field. But of the 2300 records, there are actually 202 records
that are blank in this same field yet it shows 37 to be bad. Import did not
include the other 165 records in its error table. Import does not strip any
of the contents out of that field, just alerts me that 37 are stinky. Even
when I have that particular field set for text, import still shows error and
sets up an error table. I cannot see any reason for this particular field to
not import correctly. Other fields can have some blank contents, but they
are set up for text, and import just fine. The 37 blank fields are grouped
together but others that are also blank are scattered in the field. Is there
a way I can tell the field on the table to accept anything because it is set
up for text? Or, is there a way I can delete the error table without have to
go to the into the underbelly of the database? Other people will be working
with this data and I don't want them in that area. Thanks