Search results

Thank you, this worked perfectly too.

Thank you, much appreciated!

No, it's something that I've been emailed I'm afraid.

What's normalizing the data?

Thanks Trevor, you're right, this would solve the problem. It is a one off job, but there are 3,000 lines in my file, which is why I've turned to Access as I can't do what you suggest 3,000 times! Appreciate I didn't indicate quite how big the file is in my original thread.

Sounds like exactly what I need, but I don't know how to write a function like that.

I have a table which has the following structure, where the Data column has pipe separated values which I need to separate into individual rows; SKUData N000702-EN-GB 105674|130351|14398|14421|19183|19184|19894|3692 N000542-EN-GB 17816|17817|17818|19303|21092 Plus many more...

Lightbulb moment. In my 'Subs' table, the final row was Null and Null. Having quickly imported it from Excel, I didn't notice the blank row in Excel, or once uploaded. I've just deleted that row and it seems to work perfectly. GPGeorge, I take your point in relation to simplification. I had to...

Of course, done.

Function FindAndReplace(strinput As Variant) As String Const FIND_REPLACE_VALUES As String = "SELECT [Target], [New target] FROM Subs;" If Len(strinput & vbNullString) = 0 Then Exit Function ' Bail if Null or empty string is passed With CurrentDb.OpenRecordset(FIND_REPLACE_VALUES)...

Thanks George, I realise the difficulty around substrings - I'm confident I've got this covered. I've changed 'input' to 'strinput' but just get 'Invalid use of Null' when I run it.

I'm having some issues compiling this - it doesn't like 'input'

Correct, it's not a frequent task. I'm in the process of a website migration where category URLs have changed from A to S, but not in a totally predictable way. I have a table which shows the old target URL and the new target URL, plus a table of old blog posts where the old target URLs exist...

I have two tables in my database, one with a long text field in which I'd like to perform a find and replace. However, the find and replace is not static. So in my second table, I have the values to find and the values to replace, e.g.; FindReplace AS BT CU DV EW How can I write...

Thanks for your help with this. I tried both methods, just to see what happened and they both worked well.

Ah, ok. I've never worked with UPDATE or INSERT. So, in simple language, I would do whatever extraction I need to do to create something which looks like a date in my initial query (from the raw imported data) and then use UPDATE or INSERT query to push the data into a new table but with the...

I'm importing data from eBay, Amazon and my own website into individual tables in Access. I'll then simplify each table and create queries which pull out the common data fields (such as transaction date, SKU, quantity etc etc) and append these all into a master table so that I can analyse sales...

Thanks for this, much appreciated. I'm not sure how it works though!

I have a problem that I don't how to get round, and I feel that VB is likely to be the answer here. My database imports files in the format shown above - this is fixed as it's produced by another system which has no flexibility in the output. I only need the 4th line, which is easy to isolate...

Like a charm - thank you!