Search results for query: *

Hi WildHare, You are correct, there is a step to add a primary key when you go through the process manually. However, I can't find a way to make the import specification do it automatically. Regarding the deleting the records only, that may work, but I'd be worried about running up astromical...

Hi Montrose, Thanks for the reply. My data file is a text dump from an AS400, saved as a fixed-width text file. There is not an index in this file,and there is not any one field that has unique values, but you could make an index from the combination of two fields. I'd like to have a primary...

Hi all, I am importing a text table into Access. I created an import specification and I am using a macro to automatically import this text into a table at various times throughout the day. I have a problem though, in that my text table does not have a field that I can designate as the primary...

Hi Tlbroadbent, Thanks for replying. I have seen some of Celko's nested solutions before, and one of the requirements for them was that each child can only have one parent. In my case, a child can have multiple parents. That is why I haven't tried to implement that particular solution already...

Hi All, I hope this isn't a common question that you are sick of answering. I have a big table on an AS400 I am querying through Access using ODBC. The table is basically a parent-child structure, see below for an example: PARENT CHILD CHILD-DESCRIPTION U.S...