Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 29th 05, 09:12 PM
Susie
 
Posts: n/a
Default Import External Data

I am using the "Import External Data" ~ "New Database Query" to create a
spreadsheet. The user would like to add 2 columns to the spreadsheet to add
information about the record. I know I can add two columns in the query in
the database, but the user would rather not do that so they have freedom to
manipulate the spreadsheet as they see fit. I have the spreadsheet set up to
"update" when the file is opened. Problem is, if there is a new record, and
say there is information for a record in the "new created columns" will stay
in the same row. For example,

Before update:

Row 10 may have information in the 2 columns.

After update:

A new record appears on line 6. Therefore Row 10 now becomes row 11, but
the information in the "new created columns" stays in Row 10.

So in effect, the "new created columns" does not stay with the correct
record.

Is there a way to keep the information with the correct records after updates.

Thank you in advance for your help. Hope this makes sense......

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
import data using macro chris_rip Excel Discussion (Misc queries) 0 July 18th 05 08:32 PM
Import external data "PROBLEM" Roger MacInnis New Users to Excel 4 July 13th 05 05:08 AM
Excel: Use a name with external workbook reference for data valida Fishyken Excel Worksheet Functions 3 March 11th 05 10:24 PM
refresh external data on a protected sheet ajf Excel Discussion (Misc queries) 0 March 11th 05 09:01 AM
Pivot tables, external data sources and ODBC links plato Excel Worksheet Functions 0 January 17th 05 05:07 PM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017