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...

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...

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

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...

getdate() is not a valid function in Access.

Try using Date() instead.

By the way, Select * is bad practice. It is better if you select all the fields explicitly by name....

Do this at source, if possible, by using a query instead of a table as your data source. Does that answer your question, or were you wondering how to write...

When I import dates held as strings, I usually put them in universal format (YYYY-MM-DD HH etc etc) via a derived column and then map them to the target field....

Try this[/url].

By 'static', I was referring to the file name, not the contents of the file. Unless you have done anything fancy, this will already be the case - the...

Easiest solution is to leave the destination file static, but put a File System or Script task at the end of the job which does a file copy for you,...

If your text qualifier were working correctly, you would not be seeing quotes in the output.

It seems that you are suggesting that only rows beginning with 21 are failing. But...

Please post a couple of records of source data. Do you really want...

What are your row and column delimiters set to?

Looks like you need to set your text qualifier to be " to avoid importing all the quotes.

Use a hex editor to...

RexSmith (5/20/2010)

---

This is what I had done

Dim f As String

For Each f In System.IO.Directory.GetFiles(path)

...

By using LASTROW = 1, I guess. Nice idea.

Here is your...

The problem here is not one of column and row delimiters, rather that some of the source rows are split over two rows and some only one, making a straightforward...