Search results for query: *

Hi guys and gals, Is it possible to use VBA to export the results of a query to a csv file automatically?

I have a script that loops around a directory. It opens each .CSV file in turn, replaces the string "[null]" with "". It then saves the file as a new version and deletes the original. The script works like a charm, except... When I come to load the new files into a table via DTS, it does not...

Hi all, I have a directory with 120 CSV files. I need to loop through each file and replace any instance of the string [null] with genuine null. Is this possible using VBA via excel or access?

Ok, I've tried the obvious...Control Panel, Sytstem, Advanced etc. Ticked and unticked the "Use drop Shadows" box and nothing! I still have horrible borders around the text. Does anybody know how I can get rid without using a 3rd party utility? Ta

Hi all, I want to make a user controllable rotating sphere. Exactly the same as the google earth initial view only I dont want to be able to zoom, just spin around using the mouse I then want to map jigsaw shaped pieces over the sphere for users to click and take them to another page. Any...

I have many many views and I would like to do some housekeeping. Is it possible to run a SP to find out if a view is in use by a stored procedure or another view etc? Ta

I have a form that simply updates one table. I would like a command button that when clicked, exports all collumns from that table to Excel and opens up Excel. Basically, the same procedure as File > Export... Thanks

I have a .bat script running a dts package via dts run, this is scheduled but on completion I get the message "Package has Completed". Is there any way to disable this message so the schedule can continue?

When running an import package, it fails on the Data Transformation Task with an error of "Column Name 'Col020' Could Not Be Found" Any ideas? Thanks

Please please help. How can I get the original theme back? I cant boot in safe mode. Is there a command prompt to set the theme back to normal? HELP ME NOT GET FIRED

Is this possible? I know you can do it in Oracle, but not sure what the utility is in SQL server. I can execute a SQL script using osql and a DTS package using dtsrun so Im guessing its not difficult to do! Thanks

I have 116 CSV files in a directory. They are all in exactly the same format. I need to import them all into a table via DTS. How can I do this in one package? Thanks

I am trying to create a text file via a DOS batch script and subsequently I need to add further lines to this file basedf on other processing in the batch script, how is this done? Thanks

I want to compare the contents of a directory to a list of files that are expected to exist in the directory. This will tell me which files are missing etc. Anybody got any ideas on how to do this?

I need to merge a letter that is as follows... Dear <<SCHOOL NAME>> You have the following pupils.... <<PUPIL_NAME>> <<PUPIL_NAME>> <<PUPIL_NAME>> <<PUPIL_NAME>> <<PUPIL_NAME>> <<PUPIL_NAME>> Is this possible? How can I create a list of pupils per school rather than a seperate letter for...

Without using JavaScript, how do you specify the width and height of a pop up window in HTML? I cant use JavaScript as the HTML is being displayed via a dynamic text box in a flash movie.

I have a link to an MP3, is there a way of getting the save dialog box to appear just by left clicking the link? This is so the user doesnt have to right click and save target as.

I have a page of MP3 Downloads on my flash site. I have a dynamic text box that loads in a text file containing HTML. Within the dynamic text box is 3 links to 3 seperate MP3s. What I would like to do is right click on the link and be given the option to "save the target as" at the moment I can...

I have a file on a server that is apparently in use. it holds user parameters for an application. No users are logged in anywhere but I still cant delete the file. is there any way of over-riding the lock and deleting the file? or can I find out what is locking the file? Thanks muchly

I am a complete novice as far as dBase goes. Please can anyone tell me if this is possible... Run a query from a DOS batch script that does a simple select on a number of .dbf files stored on a local drive. The closest thing I can compare it to is OSQL in SQL Server and SQL Plus in Oracle...