Creating a table by importing some data

G

Guest

I would like to create a table with 4 columns in Excel in which the first two
columns are imported from an external database, so that when I update the
table if there are new records it will insert a new row across all four
columns of my data. Is this possible?
 
G

Guest

you can copy your data into your excel sheet and can check if there is any
duplicate value by conditional formatting. Select column No. 1 and type this
in conditional formatting:
formula is:
=countif(A$1:A1, A1)>1

and choose formatting. Records those are duplicate delete them.
 
G

Guest

Thanks for your reply, I wanted to maintain referential integrity across all
four columns in each entry. So what I ended up doing was creating a list for
my data and importing the data from the external source as an XML file... I
guess there is more than one way to skin the cat.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top