Importing Excel File & Blank Lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am receiving excel files from different facilities each quarter and
importing them into Access. I am looking for advice on the best way to do
this (and automate this...code will be needed if this is the best route).

Another problem that I have is that when I import manually, it is importing
a bunch of blank lines. How do I get it to only import the rows with data?
 
I think it depends on the level of automation you want. I would follow these
steps:

- Create a inbox folder
- Create a received folder
- Define a name patter for files like: Dept01_Q1... So, you know (and the
database will know) who have sent the data and who wasn't
- Develop a function to look for file in the Inbox folder and upload any
files in there
- Program in the Windows a Scheduled Task to run your function (thru a
macro) periodically


Now... about the blank lines... I have the same problem. It happens because
in some point in time, people put some data on these rows or they have
formated them. I have 2 ways to get rid of them:

1- Select a bunch of rows directly after your data in the spreadsheet OR
2- Create some sort of filter on your import function (filtering out Null
IDs for example)

I hope I helped
Take care

Mauricio Silva
 
Back
Top