Create table with the Insert Into

[iscinar]

Create a table with the Insert Into


How to fill in my data using.

I can lay my spreadsheet.
But how to fill in the data in the same query

Sample data for the first line
AdSoyad = iscinar
Onay = -1
Tarih = 28.08.2013

CREATE TABLE MyTable
 (
    Kimlik COUNTER not null primary key,
AdSoyad VARCHAR,
 Onay BIT,
    Tarih DATETIME
  
 );


CurrentDb.Execute INSERT INTO MyTable ???????? 'How should it be

[June7]

CurrentDb.Execute "INSERT INTO MyTable(AdSoyad, Onay, Tarih) VALUES('iscinar', -1, #8/28/2013#)"

Probably should review http://allenbrowne.com/ser-36.html

[iscinar]

how it will be used in the query
CurrentDb give error

CREATE TABLE MyTable 
Kimlik COUNTER not null primary key, AdSoyad VARCHAR, Onay BIT, Tarih DATETIME);
CurrentDb.Execute "INSERT INTO MyTable(AdSoyad, Onay, Tarih) VALUES('iscinar', -1, #8/28/2013#)"

[June7]

Those are two separate sql actions. Both need CurrentDb.Execute command.

To make one action requires SELECT INTO statement but I don't think that applies to your situation. Review http://www.w3schools.com/sql/sql_select_into.asp

Why are you creating table with code?