L
Larry
Where can I find a cross reference of Access column datatypes (which
you can use in creating a table through the Table Design method) to the
appropriate datatypes to use in an SQL Create Table statement which
will be executed in Access?
I am copying data from a type of database on a computer that does not
have Access. So to do this I am programmatically looking at this other
database and creating a text file of SQL statements that I will then be
moved to the computer with Access and executed to create an Access
table and insert the data into it.
Since the computer on which I am running the application does not have
Access, I cannot use DAO, unfortunately. This is all part of a major
application which does not leave me any other methods of getting the
database off this other computer, so this is my only option.
It's not difficult, at least I have done similar things in the past
with other databases, but my only problem is that I am not sure what a
"Yes/No" field would be in a SQL statement, as well as some of the
other Access datatypes (Hyperlink, OLE Object, different types of
numbers such as Integer, Long Integer, Single, etc.). So I am looking
for something that will help me figure out what to use to convert them
properly.
Thoughts?
Thanks,
Larry
you can use in creating a table through the Table Design method) to the
appropriate datatypes to use in an SQL Create Table statement which
will be executed in Access?
I am copying data from a type of database on a computer that does not
have Access. So to do this I am programmatically looking at this other
database and creating a text file of SQL statements that I will then be
moved to the computer with Access and executed to create an Access
table and insert the data into it.
Since the computer on which I am running the application does not have
Access, I cannot use DAO, unfortunately. This is all part of a major
application which does not leave me any other methods of getting the
database off this other computer, so this is my only option.
It's not difficult, at least I have done similar things in the past
with other databases, but my only problem is that I am not sure what a
"Yes/No" field would be in a SQL statement, as well as some of the
other Access datatypes (Hyperlink, OLE Object, different types of
numbers such as Integer, Long Integer, Single, etc.). So I am looking
for something that will help me figure out what to use to convert them
properly.
Thoughts?
Thanks,
Larry