How to import SQLServer create table statement to Access?

Question by p s: How to import SQLServer create table statement to Access?
Hello I have file “.sql” which I believe is a sql statement for sql server

Some sql command from file

/****** Object: Table [dbo].[tbl2Down] Script Date: 12/1/2544 17:52:38 ******/
CREATE TABLE [dbo].[tbl2Down] (
[num] [varchar] (2) NOT NULL ,
[value] [money] NULL ,
[seang] [money] NULL ,
[day] [varchar] (10) NOT NULL ,
[sell] [money] NULL
) ON [PRIMARY]
GO

/****** Object: Table [dbo].[tbl2Up] Script Date: 12/1/2544 17:52:38 ******/
CREATE TABLE [dbo].[tbl2Up] (
[num] [varchar] (2) NOT NULL ,
[value] [money] NULL ,
[seang] [money] NULL ,
[day] [varchar] (10) NOT NULL ,
[sell] [money] NULL
) ON [PRIMARY]
GO

How I can import .sql to microsoft access

Thank you

Best answer:

Answer by Charles R
Access uses VB data types for instance varchar would be type text. In Access it is usually easier to create a table in design view. If you want to mix SQL Server and Access look into Data Projects or ADP. This lets you use Access as a front end and SQL Server as a backend.

Know better? Leave your own answer in the comments!