Hi Again,
Sorry for the late responce.
ChipR,
I could have imported a spread sheet but unfortunately the text files were about 500,000 lines + in size. Might have still worked if I had office 2007 to hand in the office but we're still stuck on 2000 here.
Adezii,
I found the same code as you ;-)
In the end I didn't use it and went for some code...
Darkside12
Last Activity: Jan 20 '14, 10:45 AM
Joined: Jan 23 '08
Location:
-
Hi Again ADezii,
Yup, I can use DTS via remote access to import data (and do regularly) as I'm admin. Unfortunately the rest of my team don't have that kind of access.
Is there any way of controling DTS from VBA?
Regards,
Dark...Leave a comment:
-
Hello again,
Thanks for the responses,
ChipR,
Great suggestion, as was my first thought when I was trying to over come this. Unfortunately Microsoft seem to have forgotten to add the import specification feature to MS Access Project ;-)
ADezii,
Your code is way better than mine and should cut down on the time it takes to process the...Leave a comment:
-
Import text
Hi,
What's the quickest way of importing text into SQL Server when importing data using Access Project (.adp)?
By the way, I can't use DoCmd.TransferT ext as the files don't have headers.
Current Code:
...Code:Private Sub ImpData_Click() Dim cncurrent As ADODB.Connection Set cncurrent = CurrentProject.Connection Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset
-
It wasn't so much getting to the column headers rather than updating the stored procedures themselves. The SQL in the proceudres ran correctly after opening them in design view and saving them.
Rather than having to do that each time a user wants to run the procedure closing and reopening the connection to SQL Server automatically updates everything in the .adp
If it took a while I would have been tempted to carry on...Leave a comment:
-
Hi Again,
I solved the issues by closing and reopening the connection to SQL Server which refreshes the stored procedures.
DarksideLeave a comment:
-
Have you tried breaking down the queries into two seperate queries. The first one should calculate the field CalcDate and the second should reference the first query instead of the table?
DarksideLeave a comment:
-
Changing Stored Procedures
Hi,
I'm trying to build a dynamic query by form. The idea is that a user can select a table in the database via a combo box and this will then change all of the text box labels on the form to match the field headers for the selected table. It also hides any text boxes that are surplus to the number of fields of the selected table.
The user can then add their search criteria into the text boxes and search the selected... -
Cheers Guys,
Figured there was a simple way of doing it. You've just saved one of my friends from having to run the same query 7903 times lol.
Thanks again,
DarkLeave a comment:
-
Hi Stewart,
Probably should have explained the problem more thoroughly.
I have an Access Project database linked to SQL Server. I'm trying to create a loop that will change the variable in a stored procedure each time through the loop and then output the results to excel.
Creating the code to generate the procedure was no problem but..... exporting the procedures output to excel is proving more difficult....Leave a comment:
-
Exporting s Stored Procedure to Excel
Hi,
A simple question but, is it possible to export a stored Procedure to excel using the docmd.TransferS preadsheet function?
If not, what is the easiest way to accomplish this? -
Cheers worked a charmLeave a comment:
-
Rename File Do Loop Error
Hi,
I'm trying to create a do loop that renames files in a folder.
My current code looks like this:
[code=vb]
Private Sub Rename_Files_Cl ick()
Dim VPNPath As String
VPNPath = Dir("C:\Temp\*. txt")
Do While Len(VPNPath) > 0
Name "C:\Temp\" & VPNPath As "C:\Temp\" & Left(VPNPath, 4) & ".tx1"
Loop
...
No activity results to display
Leave a comment: