Import table with redundant data

[Guest]

This is my first post but I have relied on many of you for answers to
questions so Thanks much for all the help!

I am trying to import a table 3 times a day from an email account. The
problem I'm having is that the exported table (I had the option of getting a
native Access table, Excel, or CSV data) has repetitive data. There are
about 30 fields with only 2 of them containing different data (date/time
stamp for a comment and the comment itself). The other 28 fields simply
contain the same entry as the first line repeated over and over. Even the
"Primary Key" field repeats. I did a select distinct query for the Primary
Key and found that 43,000 'records' actually was only 1300 records (1300
actual incidents).

For example:

PK time comment
1 12:00 hello
1 12:00 this
1 12:01 method
1 12:02 makes many
1 12:04 records
2 14:00 Please
2 14:00 help!

I've thought that cycling through the temporarily imported table and
concatenating the comment field to a memo field in a permenant table would be
the way to go but for the life of me I can't figure out the VB code or query
if possible.
Thanks for the use of your neurological efforts.
Zip

 

[John Nurick]

One of the "concatenate" functions here

http://www.mvps.org/access/modules/mdl0008.htm

and here
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

should do what you need. Probably I'd use the first, modifying it to
concatenate the values with a space between them instead of the default
semicolon.

 

[Guest]

Thanks John! This should do the trick.

One of the "concatenate" functions here

http://www.mvps.org/access/modules/mdl0008.htm

and here
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

should do what you need. Probably I'd use the first, modifying it to
concatenate the values with a space between them instead of the default
semicolon.