Recent content by twoplustwo

Afternoon all, I am trying to extract some values from a PDF (attached) and write them to an Access database. I am unsure of the approach, especially extracting values from the file. Thanks for any suggestions. Cheers

I did try this: sSql = "UPDATE " & sFileName & " SET " & sFileName & ".Field5 = ""'"" & [Field5]" To add an apostrophe to the values in Field 5 to no avail. Error "No value given for one or more parameters." was raised. sFileName has the .csv suffix - might this be causing a problem...

Hey guys, hope you're all well. I am importing a large text file via ADO. A given column contains both numeric and text values - these are identifiers for a product type. When I read the file to the recordset the first value sets the variant array field type (in this case double). The text...

The routine attached provides the following attached messagebox. Sub DoIt() Dim sURL As String Dim sEnv As String Dim xmlhtp As New MSXML2.XMLHTTP40 Dim xmlDoc As New DOMDocument 'sURL = "http://webservices.gama-system.com/exchangerates.asmx?op=CurrentConvertToEUR" sURL =...

Morning guys, hope you're all well. Still trying to crack this with little success. Any suggestions?

Tell a lie... With xmlhtp .Open "post", sURL, False .setRequestHeader "Host", "marketinformation.natgrid.co.uk" .setRequestHeader "Content-Type", "text/xml; charset=utf-8" .setRequestHeader "soapAction", "http://www.NationalGrid.com/MIPI/GetPublicationDataWM"...

I've updated the top half of the sub with the National Grid details. I am not sure on the part from "With xmlhtp" Thanks for your help with this guys! Sub DoIt() Dim sURL As String Dim sEnv As String Dim xmlhtp As New MSXML2.XMLHTTP40 Dim xmlDoc As New DOMDocument 'sURL =...

Thanks Spike. I guess I am interested in the "Pull API" information? The data items listed are accessible via this method.

Hi Spike, I wouldn't know where to start. Any decent links? Cheers.

Hey Chaz. SRC? It's not looking likely. Anyone else have any thoughts?

What's in the tables out of curiosity? If I wanted to do this and display the results I would probably build the SQL in the VBA editor, passing variables from my form/user. I would then pass that SQL to a query via the QueryDef...

Hi guys, bit of a tricky first for me. I need to pull back the data returned from the below link to a database. Ideally I would like to have control over what is being read in so I'd like to pass the data to an array first. Once the web query has run the URL does not update etc... The trouble...

Hi Flank, read up on data normalisation. This will help give context to the salient advice offered above.

I was going to give it a try... I can try the upsizing wizard in Access to generate the SQL Server database. Edit: I'm dling SQL Server 2012 at the minute.

Hmm absolute hosting path perhaps. (D:\Hosting\9328479\html) The DSN is ns05.domaincontrol.com What type of link am I attempting? I am unsure with the database now being (I think...) located on the server via FTP.