Search results for query: *

Thanks for your reply Paul. I tried the VBA code: DoCmd.TransferDatabase acImport, "Microsoft Access", "<path & name of database>", acTable, "<source table>", "<destination table>", <structure only?> False It asks for the password, but then still doesn't work unfortunately. It's definitely...

Hi All, I'm simply trying to import a table from a password protected database into another database. I've used the 'TransferDatabase' macro command, which runs and prompts the user to enter the password. I type in the password, but nothing happens! No table has been imported & it's driving me...

Thanks anotherhiggins, The problem is that I don't get chance to do the 'Text to Columns' wizard - as the database just spits it straight out into Excel, & once it's done that, the data is already incorrect. I was hoping that there might be a secret button in Excel that turned off it's...

The problem is that I cannot format the sheet before the code is entered onto it as it creates the sheet at the same time that it is filling it with data, so by the time I come to it, it has already decided that "2E1" is going to be a number, and so if I then format the cell back to text, I get...

Hi Folks, I'm at that point in Excel again where I can't seem to find an answer anywhere! I'm dealing with a set of alphanumeric codes that I'm exporting from a seperate database into Excel as a CSV file. The problem occurs with some codes that begin with a number & contain an E. For...

Thankyou VBAJedi! That's Excellent! Just what I needed. Ian T

Hi Folks, My problem at the moment is that I need to put values into filtered cells using a macro, but leave those that are not shown alone. I am doing this at the moment by using a macro to auto-filter the data for a specific criteria, & then looping through each record (row) and getting...

Thanks :)

I am stuck! I need to import data from Excel into Access. The problem that I have is that one of the fields is a number that contains more than one decimal. i.e. &quot;6.1.1.2&quot;. I have tried changing the fromat to 'text'in both Excel & Access, but Access insists on importing it as a...