Actually I meant using
VB Web Developer not Access. The import only happens when the Access database is open to get the most current data into the proper Access tables. Could I simply create the needed Select statements and add then to that proc? Eventually I plam on adding a date check to that data import. So at least it wil only happen once during a given day.
Thanks,
Robert
Quote:
quote:Originally posted by Bob Bedell
Unfortunately you can't implement the stored procedure at all in Access. It doesn't support stored procedure functionality (beyond the most rudimentary DML statments), just some ANSI-92 sored procedure syntax.
So you're back to DoCmd.TransferText, BASIC I/O, or the FileSystem object to automate the file import into Access using VBA, or using VB.NET, the System.IO namespace and either the StreamReader or BinaryReader class.
Bob
|
