How to import data from an excel-file into the DB tables...

[marlun]

Hi! I wonder how I do when I want to add data from an excel-file to my DB, so it puts the data in correct tables. Does the excel-file have to be setup in a certain way or does it work automaticly, never done this before.

thanks

 

[koresnordic]

It should put each column in Excel into a differendt field in Access. It helps is line 1 has headers, so it can give the fields a relevant name.

Graham

 

[koresnordic]

Sorry, just re-read your question. You can choose to import into an existing table, but it will always put the first imported column into the first field, the secondimpoted columninto the second field, etc. (at least it does with me - anybody else know different?)

Graham

 

[marlun]

thanks for your help I will try what you said. Is there a certain way to import the file, vb-code or through a from etc. I would like to have a form where you can browse your file and then it adds the data in a table that I have chosen at an earlier state, in vb or in a query.

hope you understand what I mean

thanks again

 

[paul123456]

Wow i just noticed this..I am looking to do the same thing.. import an excel document through a form, and it ask u were is the file located? I was trying to do it with a macro but i don't think it supports import with a xls extension. Thanks, PAUL

 

[jmscruggs78]

I am also wondering how to import an excel spreadsheet into my Access form, which is already set-up to put the information into the correct table. Does anyone know how to do this?

 

[paul123456]

Im not sure how to post a thread but here..if it doesn't work post again and i'll copy and paste it



thread700-522413

Thanks, PAUL