Transfering rows from access database to sql sever database

Question

Transfering rows from access database to sql sever database

Viewing 12 posts - 16 through 26 (of 26 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Phil Parkin (5/21/2010)
da-zero (5/21/2010)
Yeah, I'm very fortunate to have never worked with Access before, so I didn't realize the getdate() function doesn't exist in Access. Apparently Now() is the equivalent (Google is your friend).
Also, I used the column DateColumn as an example.
I'm pretty sure you have to replace that with the correct column.
You beat me!

Ha! This is my revenge because you beat me earlier in this topic. (not sure this is the correct past tense for to beat, mais bon).

Revenge can be sweet on a Friday afternoon 😀

To take it even further, in the document that the OP posted as an attachment, which you clearly didn't read :-P, you can see that the OP didn't use select * but used named columns instead.

Now I'm off to indulge myself in the finest Belgian beers. 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sachinrshetty SSCrazy Points: 2062 More actions · Answer 2

There was an error displaying the preview.

------------------------------

ADDITIONAL INFORMATION:

Invalid use of '.', '!', or '()'. in query expression 'TransactionLog. TIME > DATE ()'. (Microsoft JET Database Engine)

still I m getting above error.

I have attached snap shot in next post

sachinrshetty SSCrazy Points: 2062 More actions · Answer 3

sachinrshetty

SSCrazy

Points: 2062

May 21, 2010 at 7:38 am

#1170813

Please find the attchment

Phil Parkin SSC Guru Points: 246985 More actions · Answer 4

There should be no space before 'TIME' in your query.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

sachinrshetty SSCrazy Points: 2062 More actions · Answer 5

Anyone of u please please help me guys. I have to deploy this today:crying:

Phil Parkin SSC Guru Points: 246985 More actions · Answer 6

da-zero (5/21/2010)
Phil Parkin (5/21/2010)
da-zero (5/21/2010)
Yeah, I'm very fortunate to have never worked with Access before, so I didn't realize the getdate() function doesn't exist in Access. Apparently Now() is the equivalent (Google is your friend).
Also, I used the column DateColumn as an example.
I'm pretty sure you have to replace that with the correct column.
You beat me!
Ha! This is my revenge because you beat me earlier in this topic. (not sure this is the correct past tense for to beat, mais bon).
Revenge can be sweet on a Friday afternoon 😀
To take it even further, in the document that the OP posted as an attachment, which you clearly didn't read :-P, you can see that the OP didn't use select * but used named columns instead.
Now I'm off to indulge myself in the finest Belgian beers. 😀

The * is back in the latest doc - my post was an act of prescience.

Belgian beers, you lucky ******* :smooooth: I have to wait just a few more hours before my hands land on that first glorious Friday afternoon beer 🙂

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

sachinrshetty SSCrazy Points: 2062 More actions · Answer 7

Hey parkin,

Its showing error for where clause and even then if i give ok space will be automatically inserted.

I checked its twice

I doubt whether i can use where clause in access db.

I will check in google ma frnd and revert to u

Phil Parkin SSC Guru Points: 246985 More actions · Answer 8

You can DEFINITELY use a WHERE clause in Access.

Try building the query in Access - might speed things up for you. When it's working, just grab the SQL and then paste it into your SSIS query def.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

sachinrshetty SSCrazy Points: 2062 More actions · Answer 9

Hey

SELECT ID, SiteName, DRCNum, TypeID, Point, [Time], CardNumber, FormatName

FROM TransactionLog

WHERE (ID > 5)

above query perfectly works i have used other column ID when i use Time column its giving error.

Should i have to use any other operators or inbuilt functions to check for date.

Please reply me.

Phil Parkin SSC Guru Points: 246985 More actions · Answer 10

What is the data type, in Access, of the TIME column?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

sachinrshetty SSCrazy Points: 2062 More actions · Answer 11

sachinrshetty

SSCrazy

Points: 2062

May 21, 2010 at 8:12 am

#1170855

It is Date/Time datatype

sachinrshetty SSCrazy Points: 2062 More actions · Answer 12

K guys i m extremely sorry for wasting your time. Even too gave up.

Thank u for helping me to solve my issue.

Sachin