Filter Table to be imported

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

Guest

I am importing a table into my Access Database from Great Plains Accounting
system. The table is very large. Can I filter the Columns that I do not wish
to import? If so how?
Thanks
Bashir
 
When you say "filter", does that mean the same as "exclude"? Or are you
asking about importing a sub-set of the entire dataset, filtered on one/more
columns?

One approach would be to import all the data, as is, into a "temporary"
table, then use queries to parse out the relational data into more permanent
Access tables.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Thanks for your quick response. The table that I want to import has over 100
columns and I only want about 5 columns of the data. Is there a way to limit
the columns to import or is the temporary table the only way?

Thanks

Bashir
 
That will depend on how you connect to the Great Plains data. It might not
even be necessary to "import" the data. Can you "link" to it? That way,
you'd leave the data in Great Plains and be able to see it...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top