Search results

Okay, I've eventually found the solution that will work for me (just in case anyone else has this problem in the future) Export from Query (any option) - data truncated Export from Table (with 'Export data with formatting and layout' selected) - data truncated Export from Table (with 'Export...

I wonder what the difference is between what you are using/doing compared to me. I've tried the test db on 2 different computers (both using Access 2013). I've tried exporting both from right-click on the table and also from the Export Ribbon. I've also tried opening the exported file in both...

That's what I did. Here's a couple of screenshots https://gyazo.com/1e6346e2e8ffed027eda82d34da6ce93 https://gyazo.com/cbecbeff9031fec9db63b2d79e0ddc89 Interesting that your spreadsheet is different to mine, ie your records just occupy one line but mine shows all the line breaks etc

Wow! Yes, it is all there. I've been trying to do that for the last 2 days. How did you manage it?

Okay, I've created a new blank database and put a table in it with some data

What's the best way to supply the data as I can't export to Excel?

I have a Long Text field called EbayDescription which can contain up to around 30k characters of html (always under 32k) When I try to export using External Data > Export to external spreadsheet this field get truncated to just under 4k characters. It isn't an exact number as record 1 gets...

Hi Ridders, I'm not sure how to do a stripped down version of my db, but here is the excel file (it is just one record on this one) Andrew

Hi Ridders, I'm using Access 2013 and Excel 2010, both 32 bit. I have tried to import as a table, and get the same problem if the cell exceeds a certain size. When I try this the error is "The wizard is unable to access information in the file ((File location here) Please check that the file...

Thanks The Doc Man, Yes, I have a problem which I don't know now if it is Access or Excel, but basically I want to link to an Excel spreadsheet and update one of my fields in access (it is a long text field) If the characters in the Excel field exceed a certain amount (around 7k-8k including...

Can someone tell me how to successfully search this forum? I've tried searches both with and without quotes and each time get 500 results, and to quote U2, "I still can't find what I'm looking for"

OKay, well it isn't that company as I thought. I can't see all the data in excel on the longer item, (it also isn't in the formula bar or print preview), but if I just copy the cell and paste into notepad, the entire cell data is there!

I seem to be making headway here and it may not be an Access problem, but the software company I'm leaving cutting off xls files after around 7k characters

I've been working on this for the last 5 hours without success, so perhaps someone here can help. I have an Excel spreadsheet linked as an external table, but when I try to use an update query I get the error "External table is not in the expected format", but only on certain records. The...

If anyone ever reads this - I remember now - the original database I used was called Helix Express!

Thank you very much for this - I used this this morning and it worked perfectly.

Thanks plog, Although it follows the same pattern, the number of characters can vary. In the 1st record the first dimension is 8.9, and in the 2nd record the first dimension is 14.1. Doesn't Mid work with a fixed length?

I have a field called Size. The data in it looks like: 8.9 x 12.7 cm 14.1 x 20.4 cm 22.7 x 30.5 cm I have two new fields called Width and Height. They will hold numerical data only. Is there a way using an update querie to extract just the numerical data for each dimension to populate the...

I was originally going to start this post by saying that I loved my first database. It wasn't Access but something else on an Apple Mac back in the 1980s, but now I can't even remember what it was called! Anyway, back at the turn of the millennium, I was forced to switch to PCs, and in doing so...