Import external data
in [Functions]
|
From: nordiyu on 3 Jun 2010 22:26 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.
From: FSt1 on 3 Jun 2010 22:57 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.
From: nordiyu on 3 Jun 2010 23:17 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.
From: FSt1 on 3 Jun 2010 23:32 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.
From: nordiyu on 3 Jun 2010 23:49 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.
|
Pages: 1 Prev: vendor matches Next: How to give a string of data into different columns |