A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Import external data



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 03:26 AM posted to microsoft.public.excel.worksheet.functions
nordiyu
external usenet poster
 
Posts: 11
Default Import external data

Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data
imported. Column R & S failed to extract and column U some data OK.
  #2  
Old June 4th, 2010, 03:57 AM posted to microsoft.public.excel.worksheet.functions
FSt1
external usenet poster
 
Posts: 2,788
Default Import external data

hi
post the SQL

regards
FSt1

"nordiyu" wrote:

Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data
imported. Column R & S failed to extract and column U some data OK.

  #3  
Old June 4th, 2010, 04:17 AM posted to microsoft.public.excel.worksheet.functions
nordiyu
external usenet poster
 
Posts: 11
Default Import external data

sorry sir, how to post SQL? I found thats column R&S import for text data
only and column U import for number only

"FSt1" wrote:

hi
post the SQL

regards
FSt1

"nordiyu" wrote:

Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data
imported. Column R & S failed to extract and column U some data OK.

  #4  
Old June 4th, 2010, 04:32 AM posted to microsoft.public.excel.worksheet.functions
FSt1
external usenet poster
 
Posts: 2,788
Default Import external data

hi
the SQL (structured query language) is the query language that MSQuery uses
to import the data. if data isn't being imported properly then the problem
would be in the SQL. but first you said R & S didn't import. now you say it
does but is text only.
what is the problem?

to get the SQL.... right click the query area. from the popup, select edit
query. this will bring up the MSQ dialog. at the top should be a button
entitled SQL. clicking the SQL button should produce a small text box with
the SQL query. copy that and post in here.
if the query wizard come up instead of the MSQ dialog, click through the
first three dialogs and on the forth, cllick edit with MSQ.

regards
FSt1

"nordiyu" wrote:

sorry sir, how to post SQL? I found thats column R&S import for text data
only and column U import for number only

"FSt1" wrote:

hi
post the SQL

regards
FSt1

"nordiyu" wrote:

Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data
imported. Column R & S failed to extract and column U some data OK.

  #5  
Old June 4th, 2010, 04:49 AM posted to microsoft.public.excel.worksheet.functions
nordiyu
external usenet poster
 
Posts: 11
Default Import external data

Sir, before this, column R&S (from external file) I fill with number, then
when I fill with text, the data had imported. FYI, command type is table.

"FSt1" wrote:

hi
the SQL (structured query language) is the query language that MSQuery uses
to import the data. if data isn't being imported properly then the problem
would be in the SQL. but first you said R & S didn't import. now you say it
does but is text only.
what is the problem?

to get the SQL.... right click the query area. from the popup, select edit
query. this will bring up the MSQ dialog. at the top should be a button
entitled SQL. clicking the SQL button should produce a small text box with
the SQL query. copy that and post in here.
if the query wizard come up instead of the MSQ dialog, click through the
first three dialogs and on the forth, cllick edit with MSQ.

regards
FSt1

"nordiyu" wrote:

sorry sir, how to post SQL? I found thats column R&S import for text data
only and column U import for number only

"FSt1" wrote:

hi
post the SQL

regards
FSt1

"nordiyu" wrote:

Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data
imported. Column R & S failed to extract and column U some data OK.

  #6  
Old June 4th, 2010, 05:20 AM posted to microsoft.public.excel.worksheet.functions
nordiyu
external usenet poster
 
Posts: 11
Default Import external data



"nordiyu" wrote:

Sir, before this, column R&S (from external file) I fill with number, then
when I fill with text, the data had imported. FYI, command type is table and the connection is : Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=P:\SPAREPART\Inventory Review\FY2010\Non Moving Review\Working - Non Moving items as 030510.xls;Mode=Share Deny Write;Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDBatabase Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False



"FSt1" wrote:

hi
the SQL (structured query language) is the query language that MSQuery uses
to import the data. if data isn't being imported properly then the problem
would be in the SQL. but first you said R & S didn't import. now you say it
does but is text only.
what is the problem?

to get the SQL.... right click the query area. from the popup, select edit
query. this will bring up the MSQ dialog. at the top should be a button
entitled SQL. clicking the SQL button should produce a small text box with
the SQL query. copy that and post in here.
if the query wizard come up instead of the MSQ dialog, click through the
first three dialogs and on the forth, cllick edit with MSQ.

regards
FSt1

"nordiyu" wrote:

sorry sir, how to post SQL? I found thats column R&S import for text data
only and column U import for number only

"FSt1" wrote:

hi
post the SQL

regards
FSt1

"nordiyu" wrote:

Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data
imported. Column R & S failed to extract and column U some data OK.

  #7  
Old June 4th, 2010, 09:49 AM posted to microsoft.public.excel.worksheet.functions
FSt1
external usenet poster
 
Posts: 2,788
Default Import external data

hi
that is your connection, not the SQL.
the SQL will contain your select statement.
perhaps similar to this
select field1, field2, ect from tablename where field1 = criteria

then statement can vary a lot depending on how you set it up. this will tell
what the query is instructed to return.

Regards
FSt1

"nordiyu" wrote:



"nordiyu" wrote:

Sir, before this, column R&S (from external file) I fill with number, then
when I fill with text, the data had imported. FYI, command type is table and the connection is : Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=P:\SPAREPART\Inventory Review\FY2010\Non Moving Review\Working - Non Moving items as 030510.xls;Mode=Share Deny Write;Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDBatabase Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False



"FSt1" wrote:

hi
the SQL (structured query language) is the query language that MSQuery uses
to import the data. if data isn't being imported properly then the problem
would be in the SQL. but first you said R & S didn't import. now you say it
does but is text only.
what is the problem?

to get the SQL.... right click the query area. from the popup, select edit
query. this will bring up the MSQ dialog. at the top should be a button
entitled SQL. clicking the SQL button should produce a small text box with
the SQL query. copy that and post in here.
if the query wizard come up instead of the MSQ dialog, click through the
first three dialogs and on the forth, cllick edit with MSQ.

regards
FSt1

"nordiyu" wrote:

sorry sir, how to post SQL? I found thats column R&S import for text data
only and column U import for number only

"FSt1" wrote:

hi
post the SQL

regards
FSt1

"nordiyu" wrote:

Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data
imported. Column R & S failed to extract and column U some data OK.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.