ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import External Data (https://www.excelbanter.com/excel-discussion-misc-queries/107189-import-external-data.html)

RFJ

Import External Data
 
I'm trying to import data from one spreadsheet to another using Data/Import
External Data/New Database Query.

Just experimenting with one column of data I can't seem to get it working
whatever I try. Invariably the message I get returned from MS Query is
"Invalid Bracketing name of 'xls." I get this message whether or not I use
the query wizard.

I can import data from the web OK - so that suggests something is working.

I guess, because it is my first time, I might be missing out on doing
something important.

Can SKS help out or point me to a url that guides me through (haven't yet
found one that gives me the solution).

TIA

Rob



Franz Verga

Import External Data
 
RFJ wrote:
I'm trying to import data from one spreadsheet to another using
Data/Import External Data/New Database Query.

Just experimenting with one column of data I can't seem to get it
working whatever I try. Invariably the message I get returned from MS
Query is "Invalid Bracketing name of 'xls." I get this message
whether or not I use the query wizard.

I can import data from the web OK - so that suggests something is
working.
I guess, because it is my first time, I might be missing out on doing
something important.

Can SKS help out or point me to a url that guides me through (haven't
yet found one that gives me the solution).

TIA

Rob


Hi Rob,

Maybe here you can find some clues:

http://office.microsoft.com/en-gb/as...527981033.aspx


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy




All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com