Problem with importing.

[Frank Martin]

I have used a flat-bed scanner to import a
large page of column-arranged scientific data
..

There are only two columns, but these go up
and down the page and fill it completely.

I have successfully scanned this whole page
into a table in Word2003, and then used Word
to convert the table to "comma delimited"
data.

I use the Access2003 wizard to import the
data into a table, and what I want is only
three columns which are:

CompoundID
Compound
Temperature.

Sadly the wizard has set up more columns to
match the number of columns on the original
scientific journal.

What is the correct method to get all the
data in three columns?

Please help, Frank

 

[David F Cox]

If this is a one off and you have 6 columns of data instead of three I would
I would either do a maketable based on something like:

(SELECT field1 AS CompoundID, field2 AS Compound, Field3 as Temperature
FROM mytable)
UNION
(SELECT field4 AS CompoundID, field5 AS Compound, Field6 as Temperature
FROM mytable);

or

use an append query based on fields 4 to 6 moving them to fields 1 thru 3,
then delete fields 4 through 6

 

[Frank Martin]

Thanks, I did this. I thought there might be
an easier way.
Regards, Frank



message