Re: Multiple Table Creation in Access
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 10/29/04
- Next message: MGFoster: "Re: Criteria for Query"
- Previous message: deko: "Re: Query To Find Records As Of Specified Date"
- In reply to: GK Tripathy: "Re: Multiple Table Creation in Access"
- Next in thread: GK Tripathy: "Re: Multiple Table Creation in Access"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 13:39:17 +0800
Hi GK
Our aim in these groups is to help you to find a solution for yourself,
rather than to do it for you.
If you have never written VBA code, you will have some learning to do.
If you do, looking up OpenRecordset and Execute will help.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "GK Tripathy" <GKTripathy@discussions.microsoft.com> wrote in message news:A45C6FB1-452E-4D73-B7AB-9A67386D5D7E@microsoft.com... > Allen, > Could you provide the macro or VBA assuming that the SQL statements are > stores in a table with a key to indicate order and a memo. Want a > complete > solution, as I am not a programmer. > Thank you! > > "Allen Browne" wrote: > >> How about a table, with a primary key to indicate the order, and a memo >> field to hold the SQL statements? >> >> You could then OpenRecordset(), and Execute each statment in turn. >> >> >> "GK Tripathy" <GKTripathy@discussions.microsoft.com> wrote in message >> news:D3D5C80F-57FD-4E1C-BACC-01A5518EB5B6@microsoft.com... >> > Hi, >> > I have got around 300 tables to be created in Access database using 300 >> > SQL >> > scripts. I want to do it at one go in Access. Is there any tool or >> > procedure >> > available to do this. As I know in Access using Queries I can create >> > one >> > table at one time. But, my concern is how to create multiple tables >> > (300 >> > tables) at one go.
- Next message: MGFoster: "Re: Criteria for Query"
- Previous message: deko: "Re: Query To Find Records As Of Specified Date"
- In reply to: GK Tripathy: "Re: Multiple Table Creation in Access"
- Next in thread: GK Tripathy: "Re: Multiple Table Creation in Access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
