W
Walter Cohen
Hello.
I have some data that I want to import into Access and want to know the best
way to set up the table definition.
The data is in text format.
The first three fields of each record are unique (although I'd want to have
the first field as a key).
Each record then has 30 occurrences of 5 fields.
I am using the import wizard to bring in the data and it prompts me to
identify each field along with a name, type, length,
For each of the 30 occurrences (of 5 fields) do I need to choose a unique
name for each field and also explicitly figure out the start/length of each
field?
Is there an easier way?
Example:
0001 DOG 225 A B C D E F G H I J K L M N O P Q R S T ......etc
Does the table definition have to be something like:
NAME START LENGTH TYPE
number 1 04 Text
animal 5 04 Text
total 9 04 Text
A1 13 02 Text
B1 15 02 Text
C1 17 02 Text
D1 19 02 Text
E1 21 02 Text
A2 23 02 Text
B2 25 02 Text
C2 27 02 Text
D2 29 02 Text
E2 31 02 Text
A3 33 02 Text
....
Thanks,
Walter
I have some data that I want to import into Access and want to know the best
way to set up the table definition.
The data is in text format.
The first three fields of each record are unique (although I'd want to have
the first field as a key).
Each record then has 30 occurrences of 5 fields.
I am using the import wizard to bring in the data and it prompts me to
identify each field along with a name, type, length,
For each of the 30 occurrences (of 5 fields) do I need to choose a unique
name for each field and also explicitly figure out the start/length of each
field?
Is there an easier way?
Example:
0001 DOG 225 A B C D E F G H I J K L M N O P Q R S T ......etc
Does the table definition have to be something like:
NAME START LENGTH TYPE
number 1 04 Text
animal 5 04 Text
total 9 04 Text
A1 13 02 Text
B1 15 02 Text
C1 17 02 Text
D1 19 02 Text
E1 21 02 Text
A2 23 02 Text
B2 25 02 Text
C2 27 02 Text
D2 29 02 Text
E2 31 02 Text
A3 33 02 Text
....
Thanks,
Walter