How to Create Dynamic Tables in MS-Access?

[kalkotarmr]

How to Create Dynamic Tables in MS-Access?

I will just pass the Arguments and the Code will Create the tables dynamically/run-time.

[hariharanmca]

You can use create table key word to create table like

[CODE=sql]CREATE TABLE tblTableName (lngNumericFiel dName Long, strTextFieldNam e TEXT)[/CODE]

[Scott Price]

Sorry Hari, but that doesn't work with Access/VBA. The syntax for a make-table query is:

SELECT [ALL:DISTINCT] select_list
INTO new_table
FROM source_table
[WHERE criteria ]

This can be run from VBA using the DoCmd.RunSQL command.

Regards,
Scott

[hariharanmca]

Sorry Hari, but that doesn't work with Access/VBA. The syntax for a make-table query is:

Okay No problem, But that query is common to all Database which will create table dynamically.

[Scott Price]

Okay No problem, But that query is common to all Database which will create table dynamically.

Actually it uses standard SQL language. However, Access uses a version of SQL that MS has 'optimized' for their own purposes. It's called Jet SQL, after the Jet database engine that MS Access has been using (at least up till A2003).

Regards,
Scott

[hariharanmca]

Okay that's good information. Thank you to share with me.

[FishVal]

Hi, everyone.

Actually Access does support CREATE TABLE statement.

[Scott Price]

Strangely enough, it does! Sorry Hari... I was under the impression that it didn't.

Thanks for pointing it out, Fish.

Regards,
Scott