Creating a table by importing some data

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to manage new data with external data in Excel? 1
Word Create a Phone Book using MailMerge in word 2007 0
Inserting/Deleting Columns in Tables 3
Conditional SUBTOTAL in XL210 Table 7
how do i create a table in excel 2003? 3
Lookup Data in Another Table 1

Back
Top