Search results for query: *

Hi everyone, I have a csv file with 6 million records in. When I split it into quarters I can import it (via an external table) to my ORACLE database with no problems. However, when I try to import the whole lot I get the error: "KUP-04020 Found record longer than buffer size reported" I get...

Hi everyone..... I basically have a csv file with millions of rows in, which I want to stick into an oracle database. I'm hoping that, if I'm not fussy (see below) it's a one or two line job....but I'm not an ORACLE expert! The csv file: 1:Has no headings 2:Is comma delimited 3:Has a couple...

Hi everyone......I'd be interested to hear people's thoughts on a problem I've been having. Firstly, I'm not an experienced ORACLE guru! I can get by using the GUIs and SQL to do basic stuff but as soon as it gets complicated I'm stuck. Anyway.....I have some databases which I created using...

Hi everyone.... I've currently running a query on a table with 100,000 lines of code and it's taking over 24 hours! I'm using MS Access as a front end connected to SQL Server in the background. I didn't build the query, and don't understand it yet, so am not looking at modifying it right now...

Hi everyone! I've got sql server (v7 I think) with a database linked to MS Access. Via a macro in Access I run a set of 20 queries, which with a smaller sample of data work, but not with the main dataset which has over 2 million rows. It stops on the 12th query, which is the biggest one. I...

Hi everyone, I have an access database which will be sent all over the place and used my a number of people not connected to my current network. We want certain people to have admin priveledges and some to have read-only etc. This will therefore have to be implemented using passowrds. On my...

Hi everyone! Basically I build a string in vba which looks something like: formula_string = "=R[18]C+R[36]C+R[54]C+........." and then I paste it into a worksheet. I've had no problems doing this before, but before now the string has only been around 20 characters long. Now I've added more...

Hi everyone, Any help on this would be greatly appreciated. Basically I've written an Excel 'tool' which takes some spreadsheets, exports them to access, lets access to it's thing, retrieves the results from access and produces to pretty little charts! One day it works and the next it...

Hi all, My access knowledge is very limited, and I can't figure out how to solve this. Basically I have a table with, say, 7 columns and 1000 rows. The table is full of numbers....what I want to do is to sort the values in each column (descending)....at the same time, so I can then see the...

Hi all Here's the deal....bear with me!! Using Excel 97......From a 'front end' spreadsheet....(F) Tool opens a spreadsheet (17000 lines of data) , copies it into Access , runs some queries , copies results to another Excel spreadsheet (X) and then from (X) to the original (F). Saves and...