0

NOTE: This is NOT asking how to export MS Access table design to excel. This is the opposite direction.

Given a excel sheet, it has field info (name, start position, and width). I want to export this excel sheet into MS Access table design.

The excel file:

Field 1 len = 3 start = 1
Field 2 len = 2 start = 4
......

The MS Access design table

Field name Field length 
Field 1    3 (to be appeared)
.......
  • Open Ms access and go to External Data tab then click on Excel icon from Import Group then it will open a wizard which will provide you design option as your requirements. – JSapkota Oct 24 '16 at 3:52
  • @JSapkota I tried, but it only import the excel file as regular data source. I did not see any design option. – John Hass Oct 24 '16 at 3:58
  • 1
    Are you talking about the table definition? Or including data? Can you edit your question and paste a sample? – Sir Swears-a-lot Oct 25 '16 at 9:00
  • No data involved. – John Hass Oct 25 '16 at 16:43
  • @Peter this sample OK? – John Hass Oct 25 '16 at 16:45
2

If you want to create a table using DDL (data definition language) you can use a create table statement

You don't need the start or end position. But you do need a data type and field length.

With a bit of clever work in excel, you can probably generate a create statement.

Unless you are repeating this for lots of tables it might be easier just to create the table directly in Access.

Another option is to mock up a sample table in excel with your field names and a sample row of data and import it into access. That way access will select suitable data types.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.