In one of our ASP.NET applications in C#, we take a certain data collection (SubSonic collection) and export it to Excel. We also want to import Excel files in a specific format. I'm looking for a library I can use for this purpose. Requirements: - Excel 2007 files (Does Excel 2003 support over 64k rows? I need more than that.) - Does ...
Does anybody else have this same problem, when you import data from Excel file to MSSQL Server 2005, if some column contains mostly numeric data, but even if you set the column type to varchar, the wizard fails to import those fields that fail to parse as numbers? ...
I've created a page where our partners can upload excel files with statistics using SQLBulkCopy. The file has multiple sheets and I need to add the name of the sheet into a column in the DB for each row. The names of the sheets will not change so hardcoding the names is ok. How can I solve this? ...
I have an Excel file with a large set of data. The built-in graphs available in Excel are not enough to analyze these data, so I am thinking about using some tool like octave or R. I was thinking about some method to load an Excel file directly into octave or R. I searched the web and found that many people have succeeded using by expor...
Dear All ... This is probably a very stupid question for SQL stalwarts, but I just want one SQL command. Details, I am using a data analysis tool called R, this tool uses ODBC to read data from XLS. I am now trying to read data from an XLS file. The ODBC tool in R accepts SQL commands. Question, Can someone give me an SQL command th...
I need to read in data from excel files in my c# winforms app. Any recommendations on good components for this? I've used syncfusion some years ago and that seemed to do the trick. There'll be a bunch of header lines I need to skip (so a straight ADO approach won't work easily) and then a table of data with standard columns but variable...
I have a question regarding importing( Via the import/export wizard) an excel spreadsheet into sql server 2000. Everything seems to run fine, no errors etc, but when I select the data from my table, I've noticed that it skiped the first row. I thought maybe there was a "1st row is Data headers" flag , but I can't seem to find anything ...
Been investigating for a while now and keep hitting a brick wall. I am importing from xls files into temp tables via the OpenRowset command. Now I have a problem where I’m trying to import a certain column has a range values but the most common are the following. Columns structured as long numbers i.e. 15598 and the some columns as stri...
Hi, I have code that imports from Excel sheets of a specified format. In one of the columns, most data is numeric, but non-numeric values are also present. The non-numeric values are ignored by import code, for some reason. The connectionstring looks like this: Dim FileConnectionString As String = "Provider=Microsoft.ACE.OLEDB.12....
I have multiple CSVs. they are all export from a relation DB. Now each CSV contains thousands of entries, and references to other tables represented by other CSVs file. how can i import those file in a new Database ? Shoul i create a fresh model ? Thanks John ...
I've used RODBC for some time to import Excel spreadsheets with mostly good results. However I have had no luck writing to an Excel spreadsheet. Also are there favorable differences using the xlsx format with Excel2007? ...
The task is to have SQL Server read an Excel spreadsheet, and import only the new entries into a table. The entity is called Provider. Consider an Excel spreadsheet like this: Its target table is like this: The task is to: using 2008 Express toolset import into an existing table in SQL Sever 2000 existing data in the table! Iden...
I'm using Firebird database and I need to load Excel file into a database table. I need a tool that does this well. I tried some I found on Google, but all of them have some bugs. Since Excel data is not created by me, it would be good if it could scan the file and discover what kind of data is inside and suggest a table to be created ...
We're using workspaces (tied to calendar entries) for our meetings. It looks like attendees have to be added individually, on a per meeting basis. Is there an easy way to import the attendees (from excel, or a text list). Importantly we'd like to import them all at once, not have to add each person individually to each meeting. A sim...
I need an import tools for a web app. I've been looking around and found some, just not sure about their stability. I'm using the Zend Framework for part of the project and was hoping I could find an import tool there, since I already have the framework, but couldn't see one...am I looking in the wrong place? I would like the web us...
Hi-- I have a set of tables where each table's ID key is auto_incrementing. Now my users want to import a bunch of external data that has different keys from a single csv flat file. I think the best way to do it is to lock the tables, grab the next value for the auto_increment column for each table, then for each row I insert just swap ...
I'm trying to read a 17MB excel file (2003) with PHPExcel1.7.3c, but it crushes already while loading the file, after exceeding the 120 seconds limit I have. Is there another library that can do it more efficiently? I have no need in styling, I only need it to support UTF8. Thanks for your help ...
Can You Import an Excel File to a MySQL Database using phpMyAdmin? I am looking to buy this database that has the data of all Colleges and Universities in the US. The file is in Excel format. Can this be imported into phpMyAdmin? Here is the site where I am going to buy the database from if this is possible: http://www.data-lists.com/u...
How would I go around creating a MYSQL table schema inspecting an Excel(or CSV) file. Are there any ready Python libraries for the task? Column headers would be sanitized to column names. Datatype would be estimated based on the contents of the spreadsheet column. When done, data would be loaded to the table. I have an Excel file of ~2...
Excel has a Get External Data ribbon bar in the Data tab where we can choose to import tables from SQL databases. This process worked out nicely for me. But my question is, is there any way to save this data back into SQL? Does Excel provide some API that facilitates the coding of such a function without parsing everything and doing it f...