Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I would consider a system that used SQL Server Compact to start with. You can use it with no install if you wish to (though I suggest you do, it's much easier to just assume the requisite dll is in the GAC). If subsequently you find you need more functionality (say stored procedures or TEXT/BLOB columns, that sort of thing) then moving to SQL Server will be trivial.</p> <p>If your database is regenerated every time then trying different things out is a simple as pointing to a different file.</p> <p>If you have considerable code in VBA I would suggest first moving it to VB.Net (making this, first and most error prone transition easier) then migrating that to c# if that is your desire.</p> <p>As to generating/altering the excel sheet you have three options.</p> <p>One is to use <a href="http://msdn.microsoft.com/en-us/vsto/default.aspx" rel="nofollow noreferrer">VSTO</a> though <a href="http://en.wikipedia.org/wiki/Visual_Studio_Tools_for_Office" rel="nofollow noreferrer">Wikipedia</a> is a much better description. This will be closest to your old VBA development though it has a whole different set of complexities.</p> <p>Another is to use one of the excel output libraries, there are a <a href="http://swik.net/excel" rel="nofollow noreferrer">few</a> plus many more commercial ones. I couldn't recommend any personally though <a href="https://stackoverflow.com/questions/444522/c-asp-net-import-and-export-excel-what-is-the-best-library">other's here have</a>.</p> <p>The last is just dump out csv and let excel deal with it when you open it.</p>
    singulars
    1. This table or related slice is empty.
    1. POAlternative to MS-Access/Excel for Spreadsheet Manipulation
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USShuggyCoUk
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYet another person with no reading comprehension. The problem is CODE, not data management.
      singulars
      1. PO
      1. USDavid-W-Fenton
    2. COFFS - most of my post was devoted to code, or did you not bother to read past SQL server compact which is to make the code easier (and given his edit would make his deployment easier too!!)
      singulars
      1. PO
      1. USShuggyCoUk
    3. COAh, I see. You're pissed off in since your job is access solutions and you dislike people knocking it. Read MY post. do you see me knocking access? He is interested in moving to c#, is there a linq to Jet provider (barring this guys work http://www.codeproject.com/KB/linq/linqToSql_7.aspx)?
      singulars
      1. PO
      1. USShuggyCoUk
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload