Comments by Runner55Code

Runner55Code 2-Dec-13 8:28am View

I'll search Google for how to read the table names and loop through. I'm good with Access weak in VBA.

Runner55Code 2-Dec-13 8:26am View

You are right. Simplified it and made it a question. Thanks.

Runner55Code 23-Nov-13 12:32pm View

INSERT INTO tblDataMaster
(
IDNumber,
[Date],
Firstname,
Lastname
)
SELECT
tblDataMaster.IDNumber,
tblDataMaster.Date,
tblDataMaster.Firstname,
tblDataMaster.Lastname
FROM tblDataMaster;

Now...how do I take this query so I can run if from a module?

Runner55Code 23-Nov-13 12:28pm View

Yes...I have an append query that pulls files with a date on the back end (...on the back end of the file name). I want to write in vba (...Access code) and change it a little so I don't have to type in the new file name (...because of the date at the end of file) every time I run it. Then run a module (...or whatever) to append the new data to the master table. I'm shocked at how "help" web sites can make the simplest thing so complex.

Runner55Code 23-Nov-13 10:52am View

Thank you for your response but it doesn't really answer the question. I need to know how to add the Filename and DateTime on each import.

Runner55Code 22-Nov-13 13:36pm View

Will do. Sometimes they instructions on the web can be very confusing. I wish I knew where to go that would explain all the { [ etc. Sometimes simple examples go along way!

Runner55Code 22-Nov-13 13:22pm View

DECLARE @tname VARCHAR(150)
DECLARE @fname VARCHAR(150)

SET @tname = 'C:\DataImport'
SET @fname = 'ImportMe.csv'

INSERT INTO TryTest
(
RecordDate,
EmailAddress,
NameFirst,
NameLast,
Addr1,
Addr2,
AddrCity,
AddrState,
AddrZip,
Phone,
Production,
AdvisorType,
PlacementID,
currentFileName,
ImportDate
)
SELECT
[Record Date],
[Email Address],
[First Name],
[Last Name],
[Street Address],
[Address 2],
City,
State,
[Zip/Postal Code],
PHONE,
Production,
[Advisor Type],
[Placement ID],
@Fname AS FileName,
GETDATE() AS ImportDate
FROM OPENROWSET( BULK , @tname, FORMATFILE = @fanme) AS a;

It doesn't like the comma after BULK and it doesn't find and of the field names after the Select.

Msg 207, Level 16, State 1, Line 26
Invalid column name 'Record Date'.
Msg 207, Level 16, State 1, Line 27
Invalid column name 'Email Address'.
Msg 207, Level 16, State 1, Line 28
Invalid column name 'First Name'.
Msg 207, Level 16, State 1, Line 29
Invalid column name 'Last Name'.
Msg 207, Level 16, State 1, Line 30
Invalid column name 'Street Address'.
Msg 207, Level 16, State 1, Line 31
Invalid column name 'Address 2'.
Msg 207, Level 16, State 1, Line 32
Invalid column name 'City'.
Msg 207, Level 16, State 1, Line 33
Invalid column name 'State'.
Msg 207, Level 16, State 1, Line 34
Invalid column name 'Zip/Postal Code'.
Msg 207, Level 16, State 1, Line 35
Invalid column name 'PHONE'.
Msg 207, Level 16, State 1, Line 36
Invalid column name 'Production'.
Msg 207, Level 16, State 1, Line 37
Invalid column name 'Advisor Type'.
Msg 207, Level 16, State 1, Line 38
Invalid column name 'Placement ID'.

What am I doing wrong.

Runner55Code 22-Nov-13 12:01pm View

Wow...excellent. Thanks

Runner55Code 22-Nov-13 11:50am View

Some are really old...and they have no answers. If there is an answer...I'll keep it but your right...I don't have to delete them...just wanted to clean up. Thanks for all your help!

Runner55Code 22-Nov-13 11:46am View

Ok, that makes since...how do I get to "one of the forums"?

Runner55Code 22-Nov-13 11:45am View

Deleted

Makes since...how do you get to "one of the forums"?

Runner55Code 16-May-13 17:30pm View

Looks like the answer that scottgp gave should work.

Runner55Code 16-May-13 17:28pm View

I need to find out how many other words are not like SaveOn and a count of them.

Runner55Code 16-May-13 17:27pm View

The query needs to parse out differences based on the format. If I make everything uppercase then it defeats the purpose of the query.

Runner55Code 8-May-13 13:05pm View

Ok, I'll work on it...but PostgreSQL seems to have made something relatively simple - complex.

Runner55Code 8-May-13 12:45pm View

For a beginner (...in PostgreSQL) the http://stackoverflow.com/a/1491329[^] solution is a bit confusing.

Comments by Runner55Code (Top 16 by date)