Board index Database Programming

How to INPUT data to an SQL Anywhere database via Visual Basic/Access?

How to INPUT data to an SQL Anywhere database via Visual Basic/Access?

Post by Jeff Bernstei » Wed, 10 Jun 1998 04:00:00



Greetings!

I have three comma-delimited text (CSV) files that I'd like to load into an
SQL Anywhere database via a Visual Basic or Access front end. I can drop
tables via code, I can even create tables via code. What I can't seem to do
is use VB/Access as a conduit to bring the data from the CSV files into the
SQL Anywhere database.

The documentation for VB tells how to return data from an ODBC-connected
database but how about putting data into an ODBC-connected database?

Thanks for your attention!

Jeff

 
 
 
Top

How to INPUT data to an SQL Anywhere database via Visual Basic/Access?

Post by James Summe » Wed, 10 Jun 1998 04:00:00


Can't you just Import the CSV file into the Linked table?

On Tue, 09 Jun 1998 08:37:42 -0700, "Jeff Bernstein"


>Greetings!

>I have three comma-delimited text (CSV) files that I'd like to load into an
>SQL Anywhere database via a Visual Basic or Access front end. I can drop
>tables via code, I can even create tables via code. What I can't seem to do
>is use VB/Access as a conduit to bring the data from the CSV files into the
>SQL Anywhere database.

>The documentation for VB tells how to return data from an ODBC-connected
>database but how about putting data into an ODBC-connected database?

>Thanks for your attention!

>Jeff

-----------------------
James Summers
Befuddled VB and Access programmmer

 
 
 
Top

How to INPUT data to an SQL Anywhere database via Visual Basic/Access?

Post by Lior Lange » Fri, 12 Jun 1998 04:00:00


Hello.
 When openning the database and recordset, te defaulte value is read only
(dbdynaset,0) it need ti be changed to 1
Lior Langer


>Greetings!

>I have three comma-delimited text (CSV) files that I'd like to load into an
>SQL Anywhere database via a Visual Basic or Access front end. I can drop
>tables via code, I can even create tables via code. What I can't seem to do
>is use VB/Access as a conduit to bring the data from the CSV files into the
>SQL Anywhere database.

>The documentation for VB tells how to return data from an ODBC-connected
>database but how about putting data into an ODBC-connected database?

>Thanks for your attention!

>Jeff

 
 
 
Top

How to INPUT data to an SQL Anywhere database via Visual Basic/Access?

Post by David Freita » Fri, 12 Jun 1998 04:00:00



>Greetings!

>I have three comma-delimited text (CSV) files that I'd like to load into an
>SQL Anywhere database via a Visual Basic or Access front end. I can drop
>tables via code, I can even create tables via code. What I can't seem to do
>is use VB/Access as a conduit to bring the data from the CSV files into the
>SQL Anywhere database.

>The documentation for VB tells how to return data from an ODBC-connected
>database but how about putting data into an ODBC-connected database?

In Access you can use the TransferText macro with parameters to import the
csv files.

In VB you can read the files in using 'input' and construct an insert
statement or open an RDO resultset or a DAO recordset and set the fields to
the appropriate values but this would require some dedicated programming.

David

 
 
 
Top

1. Migrating from Visual Basic 3 SQL 4.0 to Visual Basic 5.0 and/or SQL Anywhere

We have a Visual Basic 3.0 project currently using Watcom SQL 4.0 on several
different platforms.  We would like to bring this project forward to newer
versions VB and SQL.  Can anyone answer these questions:

1) Would our existing VB 3.0 project that makes Watcom specific calls to the
database (not ODBC) be supported by latest SQL Anywhere package?  Or, would
we have to re-write all the code?

2) Has anyone gone through this process, and if so, did you find the
transition easy or a nightmare?

3) Are the any unexplainable issues with the latest SQL Anywhere that have
disabled your database, corrupted data or brought your software to a sudden
halt?

4) Does the SQL Anywhere product support replication with 'Rules' that allow
us to move data/orders from one site to another with ease?  Can it do this
one the Internet with encrypted data transfer.

5) Are we better to explore VB 5.0 and MS Access / SQL Server ???

Any answers would be welcomed.

Thanks,

Kevin Dalby

2. jd3 on w2k problems

3. SQL Anywhere 5.5.04 with Visual Basic 5 / Visual Basic 6

4. Hidding code

5. Application Development: MS-Access, Visual Basic, SQL Server, SQL Anywhere

6. Saving and accessing files from CDROM

7. DTS script in Cor C++

8. Sybase from a data aware visual basic control via pathway access

9. Connecting to Access via Visual Basic via Internet

10. Connect to SQL Anywhere database with Visual Basic aplication


All times are UTC
Board index