Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL-CREATE TABLE> list of datatypes for dBase, Paradox, Sql Server

Status
Not open for further replies.
Andy7777

Andy7777

Programmer
Sep 2, 2002
11
GB
Hi,

I have writen a VB app (uses ADO 2.6) that connects to various databases and spreadsheets and creates tables within them. It currently works with Access, Excel and SQL Server but I also need to connect to dBase, Paradox, Lotus123, Oracle and text files.

Depending on the database/spreadsheet, the DATATYPE in the SQL statement 'CREATE TABLE Table1 (FieldA DATATYPE, etc.' needs to vary. Is there a table somewhere of datatype equivalents between the databases (especially dBase, Paradox, Oracle)?

Also, with text files, am I right in thinking that the 'CREATE TABLE' SQL statement can't be used? Do I need to use 'ALTER TABLE' to achieve the same thing?

Thanks for your help.

Andy7777
 
Status
Not open for further replies.

Similar threads

sal21
  • Question
scraping table in web page 3
2
Replies
24
Views
2K
strongm
strongm
2009luca
  • Locked
  • Question
TWO table with the same classname 1
Replies
3
Views
222
Andrzejek
Andrzejek
Ken01
  • Locked
  • Question
Extraction of Picture box point / pixel colors. 3
Replies
13
Views
1K
klima
K
2009luca
  • Locked
  • Question
CHECK color of shape 2
Replies
5
Views
237
strongm
strongm
2009luca
  • Locked
  • Question
population of italy live/real time
Replies
11
Views
278
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top