Greetings! I've been lurking looking for ADP tips from this site for some time trying to crack a problem I have. Here's the run down:
The app I'm designing must take input from several flat files. I've designed tables to match the flat file spec and it transfers properly while using a role that has create tables permission.
However, I'm trying to make it so any user can perform this action and a typical docmd.transfertext requires the create statement for some reason. Thus if I attatch an import spec I believe I can avoid the create call on SQL server.
Questions:
Is there any way to programmatically create an import spec within VB or another work-around that skirts the create table call without using the import wizard?
Is there a better way to upload than docmd.transfer text for CSV's?
On a completely unrelated note, the CSV transfer time is attrocious, does anyone have recommendations? Perhaps load the file into an array and upload that way?
The app I'm designing must take input from several flat files. I've designed tables to match the flat file spec and it transfers properly while using a role that has create tables permission.
However, I'm trying to make it so any user can perform this action and a typical docmd.transfertext requires the create statement for some reason. Thus if I attatch an import spec I believe I can avoid the create call on SQL server.
Questions:
Is there any way to programmatically create an import spec within VB or another work-around that skirts the create table call without using the import wizard?
Is there a better way to upload than docmd.transfer text for CSV's?
On a completely unrelated note, the CSV transfer time is attrocious, does anyone have recommendations? Perhaps load the file into an array and upload that way?