Recent content by GregTheGeek

Thanks again for the input, TonHu. I finally have the ability to load large XLSX files using the XSSF eventmodel. I started with this code, and did what we all do: tweaked it! [thumbsup2] GTG

TonHu, According to the page you linked to, SXSSF does NOT support reading files. However, it seems that instead of using the usermodel of XSSF, using the eventmodel may be what I'm looking for. It also allows for streaming of the file. Thank you again for your input! GTG

TonHu, I will give it a try. Thank you! GTG

I've revised my answer unnecessarily. This is why I call myself a geek. For the OnClick event of the button on the sub-form... Private Sub Command0_Click() On Error GoTo click_Error 'stop screen updates DoCmd.Echo False 'set the tag property Me.Parent.Tag = "hide"...

Try: For the OnClick event of the button on the sub-form... Private Sub Command0_Click() DoCmd.Echo False Me.Parent.Tag = "hide" 'this is some control on the parent form which will receive focus Me.Parent.Controls(1).SetFocus End Sub For the GotFocus event of the control on the parent...

If you are looking to do this in a SELECT statement, try this: SELECT DATE_ADD(`baseline`, INTERVAL 1 MONTH) AS 'ProjectedDate' FROM {TableName}... Hope this helps! GTG

Let's look for a moment at what, exactly, a primary key is. "The primary key of a relational table uniquely identifies each record in the table." (http://databases.about.com/cs/administration/g/primarykey.htm) If, by the nature of your data, multiple fields are required to uniquely identify a...

Dian, Thank you for your response. The data, unzipped, is nearly 400MiB - my previous estimate was a little low. Why simply opening this file with POI is causing the heap is bloating to over a gigabyte is beyond me. The main reason I'm using Java (aside from legacy support) is because most of...

Hello. I am working on updating a Java application that was originally meant to load XLS files into a database table - MySQL, if you're curious. It utilizes the Apache POI libraries, in part, to make this happen. It's not fast, it uses a lot of memory, but it works. Now that our organization...

r937, There are a few issues with your suggestion: 1. Excel does not parse the fields correctly either. I would end up with extra fields in the problem record(s). 2. Excel should never be used as a solution in this way. Never. It's not cross-platform (meaning it doesn't run on Linux) and...

Andrew, thanks for the input. Unfortunately, I do not have control over the format of the file. I wouldn't be here if I did. :-D GTG

Hello all, I am trying to load a CSV into a mySQL table using the LOAD DATA INFILE command. There is (at least) one record that is causing an issue with the load. A text field in the record *contains* quotes and commas. Example: {...},ABCD,"This is some text in a field. It contains commas...

My apologies, I misunderstood the intent of your message. Just to be clear, you are telling me is there is really no way to do what I want by only using a macro? Unfortunately custom toolbar/menu controls will only reference macros (at least in Access 2K/2K3). I guess I will have to create a...

MajP, Thank you for your response. The function itself opens a form (which resides in the BE MDE), so I don't want to create yet another form just to call this function. My users are on a technical level, so really, using a macro is just for convenience, not aesthetics. * If I call the...

I have a back-end MDE (BE) that holds my functions, subs, and class modules. I then have this BE MDE referenced in my front-end (FE) MDB. Everything was great... until today. This thread gives a good idea of what I'm trying to do, but comes just short of giving the answer I need...