Replication ID Import to Excel

[brian7268]

Hi,

I have 2,000 access databases that are structured the same way. I want to import and compile 1 of the tables from the databases into excel. I have a macro written that does this no problem, but I just realized it is not importing Number fields with field size of "Replication ID". This is critical to eventual be able to do the analysis I am looking to do. Is there any way to have excel import the Replication ID?

Any help would be great.

Thanks!

 

[Pat Hartman]

In a query, convert the ReplicationID to text. Then export the query rather than the table.

 

[brian7268]

Pat - thank you for the reply. That solution would require me to run that query on every database (2,000+). I was hoping to find a solution from the excel end that would allow it to be imported from Access.

I suppose I could write a macro to run that query on each database, but I feel like that would also take a long time.

In a query, convert the ReplicationID to text. Then export the query rather than the table.

 

[Pat Hartman]

The query could be written in Excel.