GitHub

ckameni/MS-Access-Data-Import-

If Nz(Me.txtFilename, "") = "" Then MsgBox "Please select a file" Exit Sub End If If FSO.FileExists(Nz(Me.txtFilename, "")) Then 'tableName = FSO.GetFileName(Me.txtFilename) ' i give my Table the name ...
Ars Technica

Access, Can't import Excel spreadsheet.

I got assigned to do a little MS office work today, which includes importing some big (1mb) excel spreadsheets into an Access database file, and I only know the basics for these two programs. When I ...
GitHub

MS-Excel-VBA-interpolation-function

MS Excel/VBA interpolation function This function enables user of MS Excel interpolate a set of data points (x, y) with a bezier curve drawn through the points of the data set. Instead of looking on a ...
Ars Technica

MS Access VBA Newbie question - "Compile Error: Expected: List Separator or )"

'Evening,<BR><BR>I've been given a task to create a MS Access db for a community support network, and have run into a small bug. As a part of this, I've created a form for data entry of new people to ...