Search results

when i try to open it in excel, excel hangs, the text file came from a data warehouse, if i tried to generate the text file again but in smaller bits and then export it in would that work ??

hi thnx for your reply, seems like a good idea, i manged to link the table but when i try to run a delete query it wont let same result, i also tried to create a new table and the appent the linked table to it but this didnt work either....any other ideas..? :confused:

its a long shot....im trying to import data from a 600mb text file into access the text file has had its headers removed.. so i have created a new table with the same column headers but when i try to import the text file to the table created i keep getting "invalid argument" I cant see any...

Sub Reg() Dim TeamVar As String TeamVar = Range("TeamVar").Value Range("B8:G24").Select Selection.ClearContents With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=MS Access Database;DBQ=S:\Access\dB\Details.mdb;DefaultDir=S:\Access\dB;DriverId=25;FIL=MS...

Region FIN: IIf([Region]="NI*","FIN",[Region]) tried this but doesnt work

Hi im a newbie to access i have a column with entries in it what im looking for is, lets say everything NI* and when it finds all that is NI001, NI98 etc etc it changes the NI* entries to FIN my column is called Region, thanks to all who post and i hope you can help :confused:

hi all I have a db that does some basic queries and outputs an excel file, now the problem is; everytime i run the db the db size increases i am upto almost 450mb i delete all records at the end but to no avail please help and many thanks to all who post :confused:

whoops, its an excel problem but im using vba to call the txt file, after sheet 1 it puts the over flow data into sheet 2 then the macro does the rest :o

Hi all I’m a newbie so any help would be very much appreciated I am handling large text files With more than 65000 rows is there a way to import the text file and when the rows go over 65000 it would then move onto the next sheet and put the rest of the data there. Hope you can help many thanks...

again thanks alot and your right it cant return in a text box, well if you manage ill be very greatful thanks, if you bdont still thanks for all your help :)

what you guys have helped with any is great i thought that was a bit much thanks for posting any way

massive respect that worked superbly sj mcnabey thanks for breaking it down for me this way i learn smoething new aswell, you are the man, now lets dig a bit deeper lets say you wanted to look through a directory "P:\TAS\rja01\" look through all the text files and when the variable matched ie...

you guys thnks v much for all your help, your the best ill let you know if it works, in minute

amazing thnks very much for posting to my reply butbim a total newbie :o so and havent got aclue when yous ay about strings etc my path name is s:\macros and the variable s ain the text file are "a,b,c" does this make any sense to you ?? pleeeeeeeees help and thnaks very much again :confused:

If I have a declared variable lets say “tuesdaydata” And I get random text files put in a drive lets say 123.txt, 548.txt etc etc But some of these files have “tuesdaydata” within the text files as a title is there code that will let me on my form opening go and look through the text files and...

onm a form i have a link what is the code to attach a file to an emai many mnay thx newbie :confused: l

hi the avc value is a variable

hi im using this Private Sub Label9_Click() Set oEmail = Nothing Set oOutlook = Nothing Dim olApp As Object, olMail As Object Set olApp = CreateObject("Outlook.Application") Set olMail = olApp.CreateItem(0) olMail.To = "marc.seenan@bskyb.com" olMail.Subject = "BP Schedule" & TabName...

hi i have lengthy macro process and was wandering how i put a progress bar on my userform nay ideas?? desperate as per usual :confused:

you guys sincerest thanks to all who posted and helped you have helped me escape the mgt b.s and hassle top guys....keep up the good work :D