Search results for query: *

Thanks a bunch Trojan

I need to import all of these files into a program that will sort all of the records for the mail stream. I am using an import template so before I import these files I need to verify that all of the data files are formatted the same. All of the files are in one folder and they are all excel...

Thanks Trojan....at least you have pointed me in some kind of direction. I dont code so this is all new to me as I am sure is obvious. I was told that I could do what I wanted with relative ease using a perl script. I am sure I will figure it out.

I have a folder that contains 500 different lists. I need to create a perl script that will compare each of these files to a master file layout and verify that they are all the same. I need it to log which files don't match the master layout.

You guys are awesome are the man!!! Harley, I had my Sum1 Table set up incorrectly. I fixed it, ran it and it worked perfectly. thanks a bunch!!!

You were right Harley. :-) I can see that my naming convention was not the best here. When I run this query; INSERT INTO Final ( ID, FacID, [Loc #], [Inn Code], Brand, Rooms, TableTents ) SELECT ID, FacID, [Loc #], [Inn Code], Brand, Rooms, TableTents FROM Samples, Sum1 WHERE...

Okay, I think I am getting closer. This is the query that I ran; Insert INTO Final ( ID,FacID,[Loc #],[Inn Code],Brand,Rooms,TableTents) SELECT ID,FacID,[Loc #],[Inn Code],Brand,Rooms,TableTents FROM Samples, Sum1 WHERE Sum1.TableNumbers= Samples.TableTents; Problem is that it didn't repeat any...

Here is what I now have; Insert INTO Final ( ID,FacID,[Loc #],[Inn Code],Brand,Rooms,TableTents) SELECT Samples ( ID,FacID,[Loc #],[Inn Code],Brand,Rooms,TableTents) FROM Samples, TableNumbers WHERE Sum1.TableNumbers< Samples.TableTents; This is giving me the following error; "number of query...

So would i use an Update Query? I am not sure I understand....sorry.

...Dim rs2 As DAO.Recordset Dim nextTbl As Label Set db = CurrentDb Dim a As String Counter = 0 myNum = Tabletents 'a = "SELECT * FROM [" & tname & "];" ' MsgBox a Set rs1 = db.OpenRecordset(a) Do While Not rs1.EOF...

...will pull 20 records of each Contact. Right now it only pulls 5 records of one contact, "William J. LaBarge". INSERT INTO Resource SELECT TOP 5 * FROM [TRF Final] WHERE ((([TRF Final].[VGI Contact Name])="Rhonda Adcox")); I need the results to look like this: Contact Name OtherField1...

I am trying to get information on how best to right a query that would produce a table with 20 of each sales rep in it from another table.

I work for a print house and our client wants to see sample data for each sales rep within the file. 20 records of each to be exact. We use the data to create print proofs.

I have a table that has 17 sales representatives (over 15,000 records). How can take 20 records from each Sales Rep and put them into 17 different tables?

I want a seperate field for each description.

Yes, I know but this is how I received the data. Any suggestions?

I have two tables one table is called BuyerGuideCodes and the other is called BuyerGuideCodesDescriptions. Below is a sample record of table BuyerGuideCodes: ID: 1 COMPANY: CJ Systems Aviation Group CodeID: SS, OP, AS, AL, AN, AO, BS, GA, HD, IT, RO, PS, TR, MK...

lespaul: Thanks lespaul! That is exactly what I did and got it all to work fine. mstrmage1768: I suggest you post back,...blahblahblah. Sorry you didn't understand.

I have joined to tables based on Group_ID. This has added nineteen different contact fields to my new table. I need to sort the contact fields according to Position order. see below sorted by postion in the following order: Program Director: Operational Manager: Medical Crew Supervisor: Medical...

I am new to both XML and SQL Server so please be patient. I have ten excel files that need to be imported into SQL server. This part of my job is done. What I need now is to export these files as tagged XML files. How do I export as XML from SQL server?