Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X.
-1
votes
0answers
17 views
Sort by selected [closed]
Sorry if this is the wrong forum for this question but I am at a loss.
I need to manipulate a csv file with 150,000+ records. I use the Find tool to select a few hundred rows at a time (randomly ...
2
votes
2answers
42 views
Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database?
Let's say I'm given a list of names and email addresses in an excel spreadsheet. I am asked to find all customers in the database who's name, and email are in that list.
I currently know of two ways ...
-1
votes
0answers
19 views
In Excel 2007-2010, how does one “attach” or “glue” or “stick” information in one cell to information in another cell? [closed]
Column A = Column Z (a name). Column B (a number) is information specific to each name in Column A. The information in Columns Z thru ZZ is deleted every night and repopulated the next day, but ...
-1
votes
1answer
114 views
SSIS SQL Result to tab delimited txt file [closed]
I have created a package that Runs a Sql Query and then puts the results into a flat tab delimited txt file.
When I opened the flat file in excel everything was in the right columns but in columns ...
1
vote
0answers
100 views
How to aggregate calculated measures involving dimension attributes?
The business case is as follows -
I have a cube of sales transactions and a dimension of parts. One of the attributes of a part is the current cost, which is non-aggregatable. A user needs to model ...
0
votes
1answer
177 views
Import batches of rows from Excel in parallel
We receive an Excel file weekly currently containing about 250k rows. The file grows by about 300 rows each week.
In SSIS I've hooked up an Excel source to an OLE DB destination to import the file ...
0
votes
0answers
312 views
Using SSIS to download an attachment from Exchange/Outlook
I am recieving a weekly email that includes an attachment of an excel file. I'd rather not how to manually drop this email in a file location or manually update the data. I'd like to use SSIS to ...
0
votes
0answers
79 views
GUID for temporary table ADO
this is what I am trying to do.
Frontend: Excel
Backend: SQL server, or mySQl
In excel, I create an array, this array I want to pass into either a temporary cache table or into a new table in a ...
2
votes
1answer
278 views
excel sheet input to mysql
I want to add about 1000 records to a table that contains 31 fields.
The worst part is those 1000 records are in the form of an excel sheet having some columns left unfilled. Is there any easy way to ...
1
vote
2answers
407 views
Is there a free software that can import excel into mysql on mac?
not csv format files, but .xls or .xlsx format excel files, is there any free software for mac, that can import data into mysql?
2
votes
1answer
733 views
Informatica Source Qualifier not working from Windows ODBC data source (system DSN) from Excel xlsx file
Reference:
https://community.informatica.com/message/62128
Windows ODBC Workflow:
Windows > Control Panel > Administrative Tools > Data Sources (ODBC) > click "System DSN" menu > click "Add" > ...
-2
votes
1answer
194 views
Sharing MS Excel Sheet over network? [closed]
Is it possible to have a Server PC running a MS Excel Sheet to which several Thin Clients will be connected via TCP/IP having Barcode Scanners? The scanner's should dump their Data in the MS Excel ...
4
votes
1answer
551 views
SSAS Cube in Excel - Show only applicable rows with KPI?
I have a cube built in SSAS 2008r2. I'm exposing it for the moment through an excel PivotTable.
I recently added a KPI to the cube, and when I show the KPI in my PivotTable interface it causes ...
1
vote
2answers
167 views
changing a range into discrete values for a field in oracle
I have a data table that contains records like this:
ZIP Ground Air
010-041 005 305
150-163 004 304
As I have it right now, it's actually an excel file but I eventually need to ...
1
vote
2answers
1k views
Update existing data with excel import
I have user table in my DB. I have 1 excel sheet having list of some users (not all) with changes. How can I Update the values given in excel sheet to my user table? is it possible with import data ...
1
vote
0answers
160 views
Update excel sheets from SQL Server 2005 linked servers
I use SQL Server linked servers to connect to Excel 2003 multiple tabs workbook. After connected, I have not problem to use select statement like:
select * FROM OPENQUERY(TEST, 'select * from [fist ...
1
vote
3answers
788 views
Create/Delete file using SQL Server 2008
I have an Excel file in C:\testing.xlsx. I am exporting data from my database table to Excel using [OPENROWSET (Transact-SQL)]1 method. Now I want to
clear or delete all rows in my Excel file by ...
1
vote
2answers
1k views
Exporting data to excel
I want to execute some stored procedure and I want to export that result to Excel. How can Do that ? I'm new to SQL. any help or tutorials about this will appreciated.
1
vote
1answer
638 views
OPENROWSET can't import an excel spreadsheet into SQL Server 2005 Express
I am trying to run the following query to select data from an excel spreadsheet:
SELECT FT_ID_SOCIETE_FF2C,FT_NOM,FT_ADR1,FT_ADR2,FT_ADR3,FT_CP,FT_VILLE,FT_TEL,FT_FAX,F10 FROM OPENROWSET ...
1
vote
3answers
371 views
EXCEL sheets batch input to Access
I have a lot of Excel datasheet (in one file)
I want to batch input to Access
but I can't find a sample code to do it
the name of datasheet in access is same as in excel
is there any code of ...
6
votes
1answer
558 views
Can someone explain the magic of Opendatasource/Openrowset?
When pulling information from an excel file (or ms-access DB) I commonly use something like this:
SELECT *
FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
'Data Source=C:\test.xls;Extended ...
