Search results

Nice to Post.These all books are very useful whenever you should have to learn about the SQL(Structure Query Language).So that These all books are good enough to create the table and access the data into the SQL.

I am giving you to some advice to convert the Access table into the SQL Query, Converting DataTypes Access: CINT(value), CDBL(value), CDEC(value), CSTR(value), CDATE(value), CBOOL(value) T-SQL: CONVERT(DATATYPE, value) -- or -- CAST(value AS datatype) Conditional Expressions...

My usual approach is to create and save the pass-through query, then create a second query which uses the pass-through as a data source and does the append. Then you have no confusion as to which environment you're in -- and you can re-map data using local Access tables if necessary.