Import overwrites Key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Two ACCESS questions

Since we converted from ACCESS 97 to ACCESS 2003

1. In Table screen, the size of the table is no longer displayed. Right
click >> Properties does not give it either. Do you know how to add the Size
column like in 97? Or how to see the size of the Table, not the database. If
not, please research it.

2. I have a problem with "Get External Data" for a table.
I have a table that was created by importing a txt file.
I let ACCESS add an index which shows as ID in the first field.
Before ACCESS 2003, For over a year, I have, each month, deleted
all the records, then "Get external Data" with the updated txt file.
Last night, it failed. It imported the first column of the Txt
file into the ID column so the ID\Key was confused and all the other data
shifted a column.
Have you seen this?
I think this is the first time, since the conversion to 2003,
that anyone has tried to update an Indexed (auto number) table. Bill did one,
but it uses a macro, and a stored a "scheme" for the import.



(e-mail address removed)
 
Good Day:

I have found a partial answer, but was still wondering if there isn't a
setting that would tell the import to ignore ID\Key\Autonumber fields

Bad news is:
1. Created a new table - had the same problem.
2. Created a new database - imported diferent data - same problem
3. Compressed and rebuilt the database several times - same problem.
4. Really bad news is that the fix listed below will have to be done for
every file that gets imported into--- UNLESS you have a "Spec" import created
and use it or a Macro that calls it ( see below).

Good
1. Solution is to simply move the ID field, which is the first field, to
last place. So when I import 12 fields, they go to the correct fields in the
table, and the 13th field (ID) gets no data.
But, there may be a case where an existing FORM depends on the order in
the TABLE

2. Work around - as noted before - delete the ID field if you can.

3. Create a "Spec" to import - Start import as usual - on last screen >>
Delete the ID field >> Add at the bottom the exact name of the missing (last)
field >> Options >> Save as ( give it a name). This works since it no longer
tries to send anything to the ID field and the last field is now included.
Each time you import you have to select the "Spec" from the options box.

4. Improvement to #3- do #3, but then create a MACRO to do the import
Macro >> New >> Import text. Fill in: Path, Spec name, etc. Then, just
run the macro to import.

I have no solution for getting table "Size" to show for list of tables.
 
Back
Top