| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from excel to a defined table in another spreadsheet
I have been having problems copying data from one spreadsheet to a defined
table in another spreadsheet. I would get all kinds of errors such as the table is not updatable or the object is not recognized. I am doing this in VB. Does anyone have any insight about the situation? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy data from excel to a defined table in another spreadsheet
What is a defined table?
If it a data pull, then it is updated by pulling data. (refresh the table) -- Regards, Tom Ogilvy "DSTDIVA3" wrote in message ... I have been having problems copying data from one spreadsheet to a defined table in another spreadsheet. I would get all kinds of errors such as the table is not updatable or the object is not recognized. I am doing this in VB. Does anyone have any insight about the situation? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy data from excel to a defined table in another spreadsheet
A defined table in excel is when you give a range a name. When you highlight
a specific range and click the box on the left and type a name in that box then press enter, you have defined a table. When I execute the SQL statement to update the data, that's when I get an error. "Tom Ogilvy" wrote: What is a defined table? If it a data pull, then it is updated by pulling data. (refresh the table) -- Regards, Tom Ogilvy "DSTDIVA3" wrote in message ... I have been having problems copying data from one spreadsheet to a defined table in another spreadsheet. I would get all kinds of errors such as the table is not updatable or the object is not recognized. I am doing this in VB. Does anyone have any insight about the situation? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy data from excel to a defined table in another spreadsheet
If you want to use a query to put data in a worksheet, use a querytable.
If you use ADO to get data using an SQL statement, then you can use copy form recordset and use your defined table as the anchor. -- Regards, Tom Ogilvy "DSTDIVA3" wrote in message ... A defined table in excel is when you give a range a name. When you highlight a specific range and click the box on the left and type a name in that box then press enter, you have defined a table. When I execute the SQL statement to update the data, that's when I get an error. "Tom Ogilvy" wrote: What is a defined table? If it a data pull, then it is updated by pulling data. (refresh the table) -- Regards, Tom Ogilvy "DSTDIVA3" wrote in message ... I have been having problems copying data from one spreadsheet to a defined table in another spreadsheet. I would get all kinds of errors such as the table is not updatable or the object is not recognized. I am doing this in VB. Does anyone have any insight about the situation? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy an excel spreadsheet into word document with a table | Excel Discussion (Misc queries) | |||
| Copy data from one Excel spreadsheet to another | Excel Discussion (Misc queries) | |||
| Application-defined or object-defined error on copy | Excel Programming | |||
| using vba copy data from .csv file into an excel spreadsheet | Excel Programming | |||
| How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming | |||
Hybrid Mode
