Geek Answers Handbook

Alternative MS-Access / Excel for table manipulation

I have an MS-Access application that formats data in two large tables (20,000+ rows), imports this data into tables, performs several queries, compares the data and displays the results as excel files.

The problem is that as the application (and the VBA code) grows, it becomes more painful to use Access, and I wonder if there is a better approach?

What would be the advantages / disadvantages of a .NET solution (C #) compared to MS-Access, and what are the best libraries, etc. use?

Greetings

Breandán

Greetings for answers so far, I forgot to mention that this application should be self-contained, I need to be able to pack the application and send it to the end user for installation on my computer. This has only a note: MS-Office and the .Net Framework are installed, so I'm not sure how MySQL is possible, etc. Will not be where it can be placed.

+5
source share
8 answers

Switching to .Net will allow you to have the best data management tools at your disposal.

, , Access: Excel Excel, , , .

, Excel Access, Access .Net, Excel.

, .

Excel, .Net , , Access.

Excel, / Excel.
, .

Excel , Excel.

:

  • Access , .
    , , .
  • Access, , Excel, , LINQ Excel (1 2) , , .

.Net, , .
, Jet - , ACE - , MSAccess.
MS.
SQL Server Compact SQLite, , DLL .

+5

, 20 000 , , SQL Server , . , , , VBA, , , , . , , . , , .

, , Perl Python. , # VB.Net. Windows Perl, Python www.activestate.com.

Excel Python python-com API, VBA, . Perl Win32:: OLE. , pyexcelerator, xlrd xlwt, Python :: WriteExcel/Spreadsheet:: ParseExcel Perl. , Py2EXE Perl Dev Kit

fooobar.com/questions/137623/...

.Net, IronPython - .NET Python, .Net. Visual Studio IronPythonStudio).

R. R - , ( , , Excel. .

+2

SpreadsheetGear - , Excel. (. ), SpreadsheetGear .NET , .

ASP.NET # VB.NET , .

: SpreadsheetGear LLC

+2

POI Apache . Java excel.

ODBC XLS. , ..

http://poi.apache.org/

POI API Microsoft OLE 2 Compound Document Office OpenXML Java. , MS Excel Java. , MS Word MS PowerPoint Java. POI - Java Excel ( Excel 97-2007). API OLE 2 Compound Document .

OLE 2, , Microsoft Office, XLS DOC, API MFC.

Office OpenXML, , (2007+) XML, Microsoft Office, XLSX, DOCX PPTX.

: Monarch Pro, ..

+1

SpreadsheetGear ! , . , - -.

+1

, SQL Server Compact. , ( , , dll GAC). , (, TEXT/BLOB, - ), SQL Server .

, , , .

VBA, VB.Net( , ), #, .

/ excel, .

VSTO, Wikipedia - . VBA, .

- excel, . , .

- csv excel , .

0

, Access . 20K . , Excel Access, Excel. Access?

, .Net Excel, FlexCel Excel Excel . .Net ClickOnce.

0

, Access. , , SQL Server. 20 000 SQL Server, , . Access ? , ?

# VB? # , . , .

-2

More articles:


All Articles