Search results

I used TransferSpreadsheet at the start, but it had problems converting some fields. I have read that TransferSpreadsheet scans the first 10 rows of the Excel spreadsheet and makes guesses as to the field datatypes. If the guessed datatypes don't match with the actual table's datatypes (and I...

I exported an Excel 2003 spreadsheet to a tab-separated text file, and then wrote some code to import the text file into an Access table. All goes fine except the fact that any pound (£) signs in the text are translated into the accented u symbol " ú " I realise it may be a charset...

OK, I've removed the LEFT JOINs and thats allowed the data to be editable; luckily the LEFT JOIN tables can be considered superfluous to the result set, but ideally I'd like to have an editable result set with that data in it. I wonder if this is possible? Hmm

Hi JR, thanks for your reply. So does that mean to make the data editable I'd have to denormalise the data? Or is there another way, without changing the table schema? It's a bit late in the dev lifecycle for me to go moving everything into "flat" structures again, so any advice would be...

Hmm it's put this post in the Tables section, not queries. Could a kind mod please move this? Thanks <embarrassed look>

I have the following query: SELECT fl.File_Name, sm.Who, v.Long_Vin, v.Short_Vin, v.Reg_Date, sm.Finance_Comment, sm.Fleet_Admin_Error_ID, sm.Allocated_to_ID, sm.Resolution_Status_ID, sm.Fleet_Admin_Note, sm.Resolution_Status_Note, prk.current_assigned_to AS parked_note...

Re: TransferSpreadsheet gives me "Error; could not create" for ImportErrors temp tabl Unfortunately I can't post the spreadsheet - it's confidential data. I think the issue is that Access (or the Jet engine) is analysing the first 10 rows of data and establishing data types for columns from...

Re: TransferSpreadsheet gives me "Error; could not create" for ImportErrors temp tabl Import Spec? No parameter of DoCmd.TransferSpreadsheet resembles an import spec; do you mean named range? No that wouldn't work either. The fields to be imported are not contiguous. There's plenty of...

Re: TransferSpreadsheet gives me "Error; could not create" for ImportErrors temp tabl Because the fields causing errors are VLOOKUPs. I tried memo datatypes, text, the fields just will not convert and so I'm resigned to having errors. The contents of the VLOOKUP fields are discarded anyway -...

Re: TransferSpreadsheet gives me "Error; could not create" for ImportErrors temp tabl Hi David - the issue is that the table "SheetN$_ImportErrors" (where N is any number from 1 upwards) is dynamically created by the TransferSpreadsheet command, not by me. However that table can only be...

TransferSpreadsheet gives me "Error; could not create" for ImportErrors temp table I am using the following code to import an Excel 2003 spreadsheet with a single worksheet (ie: one tab only) into a security-enabled Access 2003 database. DoCmd.TransferSpreadsheet acImport, ...

OK, created a new database and copied the objects over and then reinstalled Access 2003, applying SP3. Followed the guide here... http://www.databasedev.co.uk/security_wizard.html working so far. Not happy that Access just let me stumble on!!

Hi, I've used Access for a while but database security is causing me some trouble. Basically I've used the user-level security wizard to lock down objects in my database. I then added new groups, the names of which aren't important but I will refer to as group A, B, C and D. I then added...