Create Access table structure from SQL db but import bcp file
Posted on 2000-04-24
I have a slow (dialup) link to the network where my SQL 7.0 server resides. In certain situations I have the ability to have the table data sent to me via a fast link in individual tab-delimited bcp text files.
It is sometimes useful to make a local "snapshot" of the data in an Access MDB.
I would like to create a VB utility which will do the following:
1. Create a new mdb with blank tables of the appropriate structure by reading the SQL table structure over the slow link.
2. Import the bcp text data into these tables. The bcp files are named in a consistent manner based on the SQL table names.
Any ideas on how this could be done?