Search results for query: *

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

...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 "","",and quotes""",Y,{...} The pattern of...

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...

...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 function from the Immediate window, it runs fine. * If I call the function from a local wrapper function, if runs fine. * If I...

...tried results in an error stating the function could not be found. I have temporarily gotten around this by creating a wrapper function in my FE that simply calls the function in the BE. However, I don't want to have to do this in *EVERY* MDB that references the BE MDE. Thanks in advance...

Golom, Thank you for the code, it pointed me in the right direction. I finally have something working! GTG

Hello all, I have a function that will dynamically build, based on passed parameters, a connection string to our mySQL server. I need to be able to use this code on different machines, each possibly with different versions of the mySQL ODBC driver installed (3.51, 5.1, etc). I created a...

Keri, Typically, when Access prompts for a value, it means it doesn't recognize one of the expressions. This happens a lot in queries when you make a type-o in one of the criteria expressions, or specify a filed that it cannot find. If you need further help, I will need more detail. What code...

kjv1611, Not that big of a difference. As I stated in my correction, all he needs to do is change the connection string. Everything else should work fine. GTG

Oops, sorry, I just realized I misread your original post. :-( I thought you wanted to get to mySQL data, not MS SQL. Really, all you need to do is change the getMySqlConnectionString function. Take a look at http://www.connectionstrings.com/ for the connection string you think would best work...