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?

Ah! Thanks people!

353,2001,"1757,0",M353204500097,Joe,Bloggs,,19/02/1997,F,17,"Made Up St",,Oldham,"OL9 6DT",,,,05/06/2006,[null],F,,,F,[null],,,"0161 287 5844" This is an example row in a .csv. The fields that are double quoted are ones that could potentially have a comma within them. The [null] is not enclosed...

...Dim strInput As String strPath = "C:\School\Incoming_net\" 'Change the following line to match your actual 'directoty strFileIn = Dir(strPath & "*.*.*.csv") intFileIn = FreeFile Do 'Open the original file Open strPath & strFileIn For Input As #intFileIn 'Create the name and open the...

Thanks for the help guys, it's working like a charm!

Ignore my last post, fixed it.

Open strPath & strFileOut For Output As #intFileOut Bad File name or Number

Also, it doesn't like the open command.

Thats excellent! Although, it's falling over at... strFileOut = strFileIn & ".tmp" Breaking at the line after this command shows... strFileOut =

100k for all!

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

Thanks, I figured it out actually. I created a Macro and ran that via the button.

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

Because, if the schedule runs overnoght, the message stops the batch file from ending. OK has to be clicked before the next part of the script can run.

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

Not really, no! I should know better really. The best part is, the PC is brand new, a day old! we live and learn...