Prev: Microsoft Office Access an't find the object '[.'
Next: Tables and Relationships Question
From: JanelleR on 12 Mar 2010 04:12
I am new to Microsoft Access.

I have 42 different csv files that I would like to import as individual
tables into access. In each of the files the first row contains the field
names.

Unless I am missing something, Access is only allowing me to do one at a
time. Is there a way in which I can import all of them? I have them all in
one folder.
From: Douglas J. Steele on 12 Mar 2010 08:29
Yes, you need to import them one at a time. However, that shouldn't be an
issue. Take a look at what Ken Snell has at
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpFolderFiles

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"JanelleR" <JanelleR(a)discussions.microsoft.com> wrote in message
news:5EC428C3-52F2-4B27-91E0-CC0D7F142A7D(a)microsoft.com...
>I am new to Microsoft Access.
>
> I have 42 different csv files that I would like to import as individual
> tables into access. In each of the files the first row contains the field
> names.
>
> Unless I am missing something, Access is only allowing me to do one at a
> time. Is there a way in which I can import all of them? I have them all
> in
> one folder.

 | 
Pages: 1
Prev: Microsoft Office Access an't find the object '[.'
Next: Tables and Relationships Question